Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > HELP! Recordsets problem with IIS 6.0

Reply
Thread Tools

HELP! Recordsets problem with IIS 6.0

 
 
sKodi
Guest
Posts: n/a
 
      07-02-2003
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?


 
Reply With Quote
 
 
 
 
Ken Schaefer
Guest
Posts: n/a
 
      07-02-2003
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" <(E-Mail Removed)> wrote in message news:bdtlql$6mn$(E-Mail Removed)...
: 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?
:
:


 
Reply With Quote
 
 
 
 
Aaron Bertrand [MVP]
Guest
Posts: n/a
 
      07-02-2003
> it causes HTTP500 - Internal Server Error. What's up?

Tell us what the error really is.
www.aspfaq.com/2109


 
Reply With Quote
 
sKodi
Guest
Posts: n/a
 
      07-02-2003
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();
%>
----------------------------------------------------------------------


 
Reply With Quote
 
Aaron Bertrand - MVP
Guest
Posts: n/a
 
      07-02-2003
> 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.


 
Reply With Quote
 
sKodi
Guest
Posts: n/a
 
      07-02-2003
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.


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Several Recordsets...Close the Connection Each Time? Bob ASP .Net 3 02-22-2007 12:25 PM
ADO+RECORDSETS Guy Cohen ASP .Net 2 01-19-2007 06:52 PM
Working with recordsets chema.rey@gmail.com Python 2 01-08-2005 07:22 PM
Q: About how/where to store RecordSets in UserControls? Sky ASP .Net 2 03-04-2004 10:13 AM
how to mix 2 recordsets into one result table? AFN ASP .Net 5 02-11-2004 11:38 PM



Advertisments