Problem with creating a recordset

am 19.12.2007 21:43:52 von MichaelJohnson168

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

1.
2.
3. Untitled Document
4.
5.
6.
7.
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 "" & oRS("StoreName") & ""
%>

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

Re: Problem with creating a recordset

am 19.12.2007 21:52:45 von reb01501

MichaelJohnson168@hotmail.com wrote:
> 12. Set oRSp = Server.CreateObject("ADOBD.RecordSet")
ADODB, not ADOBD
--
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.