|
Unless you're hosting IE as a control I don't think you can prevent this.
Todd Smith
|
|
|
|
|
At work I have an NT 4 Server/IIS 4 setup with an Access database and some ASP pages that works withour problem. The same pages and the same database are giving me problems at home under 2K Server/IIS 5.
My ASP page looks something like this:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
if not Request("id") = "" then
Dim conn, filePath
filePath = Server.MapPath("database.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath
' Debug output code
Response.Write(Request("id") & "<br>")
for i = 0 to conn.properties.count - 1
Response.Write(conn.Properties(i).Name & ": " & conn.Properties(i) & "<br>")
Next
' end of Debug code
conn.Execute "DELETE FROM MyTable WHERE ID = " & Request("id")
conn.Close()
Set conn = Nothing
end if
Response.Redirect("complete.asp")
%>
The result of running this page is as follows:
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
--------------------------------------------------------------------------------
Please try the following:
Click the Refresh button, or try again later.
Open the maggie home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not delete from specified tables.
/mass/resourcing/delete.asp, line 18
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; .NET CLR 1.0.3705)
Page:
GET /mass/resourcing/delete.asp
Time:
27 August 2002, 19:29:46
More information:
Microsoft Support
I think it's something to do with write access to the database as I can read from it okay with a different page and AddNew causes similar problems. Any ideas on where to look to sort this out?
The debug output (when the Execute statement is commented out) looks like this:
148
Current Catalog:
Active Sessions: 128
Asynchable Commit: False
Catalog Location: 1
Catalog Term: Database
Column Definition: 1
NULL Concatenation Behavior: 2
Data Source Name: D:\Inetpub\wwwroot\mass\resourcing\masscouk.mdb
Read-Only Data Source: False
DBMS Name: MS Jet
DBMS Version: 04.00.0000
GROUP BY Support: 4
Heterogeneous Table Support: 2
Identifier Case Sensitivity: 8
Maximum Index Size: 255
Maximum Row Size: 4049
Maximum Row Size Includes BLOB: False
Maximum Tables in SELECT: 0
Multiple Storage Objects: False
Multi-Table Update: True
NULL Collation Order: 4
OLE Object Support: 1
ORDER BY Columns in Select List: False
Prepare Abort Behavior: 1
Prepare Commit Behavior: 2
Procedure Term: STORED QUERY
Provider Name: MSJETOLEDB40.DLL
OLE DB Version: 02.10
Provider Version: 04.00.4331
Schema Term: Schema
Schema Usage: 0
SQL Support: 512
Structured Storage: 9
Subquery Support: 63
Isolation Levels: 4096
Isolation Retention: 9
Table Term: Table
User Name: Admin
Pass By Ref Accessors: False
Transaction DDL: 16
Asynchable Abort: False
Data Source Object Threading Model: 1
Output Parameter Availability: 1
Persistent ID Type: 4
Multiple Parameter Sets: True
Rowset Conversions on Command: True
Multiple Results: 0
Provider Friendly Name: Microsoft OLE DB Provider for Jet
Alter Column Support: 36
Open Rowset Support: 2
Cache Authentication: True
Encrypt Password: False
Mask Password: False
Password:
User ID: Admin
Data Source: D:\Inetpub\wwwroot\mass\resourcing\masscouk.mdb
Window Handle: 0
Mode: 13
Prompt: 4
Extended Properties:
Locale Identifier: 1033
Jet OLEDB:System database:
Jet OLEDB:Registry Path:
Jet OLEDB:Database Password:
Jet OLEDB:Engine Type: 5
Jet OLEDB:Database Locking Mode: 0
Jet OLEDB:Global Partial Bulk Ops: 2
Jet OLEDB:Global Bulk Transactions: 1
Jet OLEDB:New Database Password:
Jet OLEDB:Create System Database: False
Jet OLEDB:Encrypt Database: False
Jet OLEDB:Don't Copy Locale on Compact: False
Jet OLEDB:Compact Without Replica Repair: False
Jet OLEDB:SFP: False
Jet OLEDB:Compact Reclaimed Space Amount: 24576
Autocommit Isolation Levels: 4096
Jet OLEDB:ODBC Command Time Out: 0
Jet OLEDB:Max Locks Per File: 0
Jet OLEDB:Implicit Commit Sync: False
Jet OLEDB:Flush Transaction Timeout: 0
Jet OLEDB:Lock Delay: 0
Jet OLEDB:Max Buffer Size: 0
Jet OLEDB:User Commit Sync: True
Jet OLEDB:Lock Retry: 0
Jet OLEDB:Exclusive Async Delay: 0
Jet OLEDB:Shared Async Delay: 0
Jet OLEDB:Page Timeout: 0
Jet OLEDB:Recycle Long-Valued Pages: False
Jet OLEDB:Reset ISAM Stats: True
Jet OLEDB:Connection Control: 2
Jet OLEDB:ODBC Parsing: False
Jet OLEDB:Page Locks to Table Lock: 0
Jet OLEDB:Sandbox Mode: False
Jet OLEDB:Transaction Commit Mode: 0
Derek Lakin.
I wish I was what I thought I was when I wished I was what I am.
Salamander Software Ltd.
|
|
|
|
|
Looks to me like you need to give full security access to the database for the IUSR_* ID.
Paul
|
|
|
|
|
Paul,
Thanks very much. I knew it had to be something fairly simple 
To get it working I simply added the IUSR_ account to the Domain Admins group, but surely there's a more secure way?
Derek Lakin.
I wish I was what I thought I was when I wished I was what I am.
Salamander Software Ltd.
|
|
|
|
|
Yeah, that's a pretty dubious way of doing it, you've just given your web page permission to do pretty much anything 
The more secure solution is to have your db in a sub folder of your web page and give IUSR_* full access to that folder (and obviously all it's contents).
Not sure how to do that on NT4 but I'm sure you can. Start by right-clicking on the folder, going into Properties and looking for a Security tab.
Paul
|
|
|
|
|
Excellent. Problem solved. Thanks very much ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Derek Lakin.
I wish I was what I thought I was when I wished I was what I am.
Salamander Software Ltd.
|
|
|
|
|
I want to use raw socket to intercept the ipx packets int the local netware.
I successed in IP, But now I want intercept ipx packets.
Some example codes will be better.
Mail:vcfan@myhexin.com
Can give me some information about it, Thanks a lot!
Everyone is my teacher!
|
|
|
|
|
My Web service is running fine. When I add a web Project to the solution and try to "Add a web reference" for a web service, web reference is not found.
Error Message:The proxy settings on this computer are not configured correctly for web discovery.
Please help!!!!
thanks.
|
|
|
|
|
Hello All,
I've made a simple web service in Visual Studio ASP.Net.
Problem is that I can't view a simple web service with a simple 'HELLO WORLD' WebMethod. When I see the .asmx file in browser instead of show the web service, it shows me the download dialog for download the .asmx file... What's wrong?
Please help urgently!!
Thank you.
|
|
|
|
|
farhanh wrote:
it shows me the download dialog for download the .asmx file... What's wrong?
Have you installed the .NET Framework correctly? If yes then check IIS and make sure ASMX files are one of the accepted extensions. We had some problem with ASP.NET where a virtual folder lost all references to any ASP.NET files, had to manually put them back 
regards,
Paul Watson
Bluegrass
Cape Town, South Africa
Simon Walton wrote:
"You come across a lot of people who call themselves realists, when they are actually pessimists attempting to look intelligent."
|
|
|
|
|
ok...i have already those problems and....how did u configured the asmx extensions? what is the exec or dll to execute .asmx files to configure my virtual directory?
If I installed IIS 5.0 first and then .NET why i haven't any extension referred to .asmx files in the IIS??? What's wrong?
Thanx
---
((.)) The Vortex ((.))
|
|
|
|
|
Vortex wrote:
what is the exec or dll to execute .asmx files to configure my virtual directory?
On my system it is: C:\WINNT\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll
That is a W2K server box running IIS5.0. Windows XP would be something like C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll
Also make sure your Verbs are set to: GET,HEAD,POST,DEBUG. Not "All Verbs."
Though I must stress that there are tons of files (must be 25 in front of me at least) and they all have various settings. So a re-install of ASP.NET is probably best, rather than doing it manually (we could not re-install otherwise it would have interrupted our hosting services, we did it manually but eventually we will do it "properly" in case something was missed.)
Vortex wrote:
If I installed IIS 5.0 first and then .NET why i haven't any extension referred to .asmx files in the IIS??? What's wrong?
I have to admit I honestly do not know. We had the problem but never found the cause of it. We simply had to look at a "working" ASP.NET virtual dir and manually redo the extensions. Real PITA.
regards,
Paul Watson
Bluegrass
Cape Town, South Africa
Simon Walton wrote:
"You come across a lot of people who call themselves realists, when they are actually pessimists attempting to look intelligent."
|
|
|
|
|
ok...i've found the way to resolve my problem: to those who can be interested in it i've found the file that register all the ASP.NET extensions in the IIS. Sometimes the .NET installer doesn't do his job well and it not register the ASP.NET extensions in the IIS. When it occurs, we have to use the following file: In .NET Framework directory (by default c:\windows\Microsoft.NET\Framework\<version>\ there is the file that is called : aspnet_regiis.exe
And...that's all. All the extensions (.aspx, .asmx, .asax, .ascx, etc...) have been registered!!!
Enjoy!
|
|
|
|
|
ok...i've found the way to resolve my problem: to those who can be interested in it i've found the file that register all the ASP.NET extensions in the IIS. Sometimes the .NET installer doesn't do his job well and it not register the ASP.NET extensions in the IIS. When it occurs, we have to use the following file: In .NET Framework directory (by default c:\windows\Microsoft.NET\Framework\<version>\ there is the file that is called : aspnet_regiis.exe
And...that's all. All the extensions (.aspx, .asmx, .asax, .ascx, etc...) have been registered!!!
Enjoy!
|
|
|
|
|
Hey Guys,
I am using ASP to load some data from a xml file via xsl. Now i need to sort this data, i know i could use the xsl:sort element but i need a dynamic one, which the user can change. So the user will have the possibilty to sort the data in different ways.
Is there any such function ?
Any suggestions ??
Thanks
Sonu Kapoor
da sonu 
|
|
|
|
|
I wish to create a page which has similar functions to the datagrid but with one main difference. Each record keyfield is displayed from a database which when clicked loads that record in another page.
The main difference is that I since each record will be only 1 item I would like to show more than one record per result row.
[record1] [record2] [record3]
[record4] [record5] [record6]
[record7] [record8] [record9]
Is this possible with datagrid or any of the other data controls (repeater,datalist etc) ?
or
Could I inherit the datagrid and override a method to achieve this effect?
I would prefer to avoid coding it from scratch unless there really is nothing existing that can do the job.
Thanks
It ain't what you know that matters.
Uncle Monkey
|
|
|
|
|
Hello all,
I am using javascript for client side validations and form submission in certain web pages I am developing. I have added code to submit a form, on pressing the "Enter" key. The code works fine in IE and Netscape. But unfortunately the code is not working in Mac IE. Can anyone throw light on this issue ? What are the precautions to be taken when writing client side javascript for Mac IE ? Is there a way to detect IE Mac version and add special code as we do for Netscape ?
Thanks,
Smitha
It's easy to sit there and say you'd like to have more money. And I guess that's what I like about it. It's easy. Just sitting there, rocking back and forth, wanting that money.
|
|
|
|
|
Tweety wrote:
Is there a way to detect IE Mac version and add special code as we do for Netscape ?
Yes you can look for MAC in the Request.ServerVariables("HTTP_USER_AGENT") string to detect if you are on Mac or not. Then you can look for the IE and Netscape identifiers for more profiling.
Tweety wrote:
I have added code to submit a form, on pressing the "Enter" key
Try this code, works fine on my Mac. If it does not help then post your offending code and I will have a look. I am trapping the enter key on the TEXTAREA element using the keypress event. You can put it on almost any other element and use keydown or keyup instead.
<html>
<head>
<script language="javascript">
<!--
function validate(){
return true;
}
function submitform(){
e = window.event;
if (e.keyCode == 13) document.frmMacTest.submit();
return true;
}
-->
</script>
</head>
<body>
<form action="mactest.asp" onsubmit="return validate();" method="post" name="frmMacTest">
<input type="text" name="txtName" id="txtName" value="Your name..." /><br />
<textarea name="txtDesc" id="txtDesc" onkeypress="return submitform();">
Decribe yourself...
</textarea><br />
<input type="submit" name="cmdSubmit" id="cmdSubmit" value="Submit" />
</form>
</body>
</html>
Tweety wrote:
What are the precautions to be taken when writing client side javascript for Mac IE ?
Should not be anything major, not unless you are doing "low level" stuff. Though Mac IE does seem to be less forgiving than PC IE (which is a good thing.)
regards,
Paul Watson
Bluegrass
Cape Town, South Africa
Simon Walton wrote:
"You come across a lot of people who call themselves realists, when they are actually pessimists attempting to look intelligent."
|
|
|
|
|
function subscribe(event,ourform){
if(document.all)
kcode=window.event.keyCode;
else
kcode=event.which;
var isIE = document.all?true:false;
var isNS = document.layers?true:false;
if (isIE){
cond=(event && (kcode == 13 || kcode==1 || kcode==0));
}
else{
cond=(event && (kcode == 13 || kcode==1));
}
if (cond){
if(checkemail()){
document.addelec.func.value="subscribe";
document.addelec.action="elecsubs_action.php";
document.addelec.submit();
return true;
}
else
return false;
}
else
return true;
}
And I call it as :-
<input type=button value="Subscribe" onClick="return subscribe(event,this.form)">
This code works fine in IE and Netscape.
Tweety
It's easy to sit there and say you'd like to have more money. And I guess that's what I like about it. It's easy. Just sitting there, rocking back and forth, wanting that money.
|
|
|
|
|
Tweety wrote:
And I call it as :-
Well I am not sure about what you are trying to do actually. Why detect for a ENTER key-event when it is on a button which already accepts ENTER? What are you trying to do? Stop people using the mouse to subscribe?
Anyway, your code works fine on my Mac (no modifications except commenting out the function and element calls I don't have.) I am running IE5.0 on Mac OS 9.0.
regards,
Paul Watson
Bluegrass
Cape Town, South Africa
Simon Walton wrote:
"You come across a lot of people who call themselves realists, when they are actually pessimists attempting to look intelligent."
|
|
|
|
|
Paul Watson wrote:
I am running IE5.0 on Mac OS 9.0.
You haven't upgraded to Mac OS X yet?   ;)
Jeremy Falcon
Imputek
<nobr>"C# is the answer to a question nobody asked." - Chris Losinger
|
|
|
|
|
Jeremy Falcon wrote:
You haven't upgraded to Mac OS X yet?
LOL.
It is an iMac (old style) which we use maybe once a week for Mac testing.
Though I must admit I have been lusting after the latest iMac and that new Mac OS X Jaguar. That is one awesome OS.
Oh and don't forget the iPod... mmmmnnnnn
regards,
Paul Watson
Bluegrass
Cape Town, South Africa
Simon Walton wrote:
"You come across a lot of people who call themselves realists, when they are actually pessimists attempting to look intelligent."
|
|
|
|
|
Hi,
This is probably a really stupid question. I've set up IIS under XP to point at another folder other than wwwroot (not that it should matter). Then using another account (with non-admin priveleges), I'm trying to use Interdev to create a 'solution' and edit my site locally, except Interdev is refusing to do it and giving some error message (which isn't all that helpful). What am I missing out on? The usual searches have drawn a blank so far...
Cheers,
Barry.
|
|
|
|
|
Make sure the new folder that you are using is listed within IIS as a virtual directory.
Nick Parker
|
|
|
|
|
Thanks Nick,
The part of the problem was 'user error'
It says at the top of interdev 'must have frontpage extensions installed'. Guess what?
Then I had to do the virtual directory thing
Who'd think MS stuff works straight out of the box eh?
Cheers,
Barry.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
