Problem with creating a recordset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MichaelJohnson168@hotmail.com - 19 Dec 2007 20:43 GMT

I am getting an error at line 12 involving reading from a database. I
am using IIS is installed on Windows XP.

1. <html>
2. <head>
3. <title>Untitled Document</title>
4. <meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
5. </head>
6.
7. <body bgcolor="#FFFFFF">
8.
9.
10. <%
11. Dim oRSp
12. Set oRSp = Server.CreateObject("ADOBD.RecordSet")
oRSp.CursorType = adOpenStatic
oRSp.Open "SELECT * FROM Stores", "DSN=Stores"
oRSp.MoveFirst
Response.Write "<B>" & oRS("StoreName") & "</B>"
%>
<HR>
</body>
</html>

I get the following error at line 12:

Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid class string
/MyWeb/test.asp, line 12

Can someone let me know what the problem is and how I can fix it?

Thanks

Reply to this Message

Bob Barrows [MVP] - 19 Dec 2007 20:52 GMT

> 12. Set oRSp = Server.CreateObject("ADOBD.RecordSet")

ADODB, not ADOBD

Signature

Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Reply to this Message

Webmaster Forum / ASP / Database Access / December 2007

Problem with creating a recordset