Ask a Question related to ASP, Design and Development.
-
sKodi #1
HELP! Recordsets problem with IIS 6.0
I have a problem. When I had IIS 5.1 my Dreamweaver MX created
ADODB.Recordset objects for my ASP pages. Everything worked great. But now
it causes HTTP500 - Internal Server Error. What's up?
sKodi Guest
-
ASP Recordsets
Hi there, i'm developing an ASP SQL application, and was just wondering whether for some reason this limited me to one recordset per page. the... -
Problem filtering Data through Multiple Recordsets
Hello, I am currently working on a profile page that users will go to once they log in to our website. The profile page will show the users contact... -
Persisted XML Recordsets - Disconnected Recordsets - problems
I have a recordset, client side .ASP that I save as a DOM. I pass to a server side .ASP to reconnect the recordset and update. I keep getting an... -
asp web page problem, two recordsets
oh, ok Thanks, i just thought it would be a bit sloppy to paste a whole page of code, so i am trying to create a page, and then paste the code in... -
generating recordsets
50k records should load almost instantaneously if the form is based on a single table, and there are indexes on the appropriate fields for selecting... -
Ken Schaefer #2 Re: HELP! Recordsets problem with IIS 6.0
In Internet Explorer, goto tools -> internet options -> advanced, and
uncheck "Show Friendly HTTP Errors" nd reload the page. Post the complete
error message to the group.
Cheers
Ken
"sKodi" <skodi@pisem.net> wrote in message news:bdtlql$6mn$1@news.rol.ru...
: I have a problem. When I had IIS 5.1 my Dreamweaver MX created
: ADODB.Recordset objects for my ASP pages. Everything worked great. But now
: it causes HTTP500 - Internal Server Error. What's up?
:
:
Ken Schaefer Guest
-
Aaron Bertrand [MVP] #3 Re: HELP! Recordsets problem with IIS 6.0
> it causes HTTP500 - Internal Server Error. What's up?
Tell us what the error really is.
[url]www.aspfaq.com/2109[/url]
Aaron Bertrand [MVP] Guest
-
sKodi #4 Re: HELP! Recordsets problem with IIS 6.0
Here is the error message:
--------------------------------------------------
Microsoft JET Database Engine error '80004005'
Could not find file 'C:\WINDOWS\system32\websitesskodidata.mdb'.
/TMP3tq47hehzc.asp, line 5
-----------------------------------------------------
Here is the source of sample file (TMP3tq47hehzc.asp), I've added some
comments to the lines:
----------------------------------------------------------------------------
--
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1251"%> //start of the file, defining
ASP language and codepage
<%
// FileName="Connection_ado_conn_string.htm"
//comment of DreamWeaver MX
// Type="ADO"
//comment of DreamWeaver MX
// DesigntimeType="ADO"
//comment of DreamWeaver MX
// HTTP="false"
//comment of DreamWeaver MX
// Catalog=""
//comment of DreamWeaver MX
// Schema=""
//comment of DreamWeaver MX
var MM_main_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=C:/websites/skodi/data.mdb" //connection string
%>
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
//creating of recordset
Recordset1.ActiveConnection = MM_main_STRING;
//connection
Recordset1.Source = "SELECT * FROM global_variables";
//query
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
//opening recordset
var Recordset1_numRows = 0;
%>
<html>
<head>
<title>Sample Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>
<body>
</body>
</html>
<%
Recordset1.Close();
%>
----------------------------------------------------------------------
sKodi Guest
-
Aaron Bertrand - MVP #5 Re: HELP! Recordsets problem with IIS 6.0
> Source=C:/websites/skodi/data.mdb"
These should be \ slashes, not / slashes.
Or, better yet, use server.mappath so that you are not affected by changes
to the local filesystem.
Aaron Bertrand - MVP Guest
-
sKodi #6 Re: HELP! Recordsets problem with IIS 6.0
No, there must be backslashes. It worked well on IIS 5.0 and IIS 5.1 .
However, I've solved this problem myself now. Thanks to Ken Shaefer for his
advice about IE.
sKodi Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
