ASP access to an Access Database

I have an ASP program (http://209.36.114.163/advscripts/test.asp) that can't seem to access an Access database on my website.  Here's the code I wrote for it:
<%
 Set Conn = Server.CreateObject("ADO.Connection")
 'objCmd.Open("realnet")
 'Set objRst = objCmd.Execute("users")

 Conn.Open "realnet"
 Set objRst = objCmd.Execute("SELECT * FROM users")

 objRst.AddNew
 objRst("lastName") = "Downey"
 objRst("firstName") = "Eric"
 objRst("mi") = "W"
 objRst.Update
 objRst.Close
%>
The first SET command causes the thing to bomb!  If anyone can help I'd really appreciate it!

Eric Downey
edowneyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
JamesNConnect With a Mentor Commented:
It should be:

Set Conn = Server.CreateObject("ADODB.Connection")
                                                             ^^
James
0
 
rpoffelCommented:
Your problem could be that the class ADO.Connection was replaced by ADODB.Connection.  You can check your registry to determine that your web server has got the ADODB classes installed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.