ADODB.Recordset (0x800A0E7A) Error in chapter 2

phirun · January 12th, 2004, 04:33 AM

I have just bought the book and follow the step in the book.
My system is windows XP and IIS 5.1. The example in chapter 2. I got the error as following:

ADODB.Recordset (0x800A0E7A)
Provider cannot be found. It may not be properly installed.

What have I done wrong? Thanks in advance

pgtips · January 14th, 2004, 08:12 AM

Probably just a typo in your connection string. If you can't see anything wrong with it then post it here and we'll take a look.

phirun · January 14th, 2004, 10:36 PM

Thank you so much.
I have checked the code again. I typed it correctly.

Here is the code:

<%@Language=VBScript%>
<html>
<head>
<title>Home Page</title>
</head>
<body>
This line from HTML

Next line from ASP will work 
if ASP extensions installed correctly: 
<%
response.write "From ASP"
%>

Next line from ADO will work if a DSN named sailors has been set 
for the database which is named SAILORS.MDB.
<%
set oRS=server.createobject("ADODB.recordset")
oRS.open "Select * from People", "DSN=sailors"
oRS.movefirst
response.write "" & oRS("PeopleNameLast") & ""
%>

Finished test page
</body>
</html>

Please give me suggestion! Thanks again

pgtips · January 15th, 2004, 08:06 AM

Must be a problem with the 'sailors' DSN then. I assume the book has steps to create the DSN? Did you have any problems setting it up?

You can test the DSN using a udl file. Just create a new file called anything.udl, then double-click it and a "Data Link Properties" dialog will appear. On the Connection tab, under "Specify the source of data", choose the "Use data source name" option and select the sailors dsn from the drop-down. The hit the 'Test Connection' button and see what happens!