Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ASP access to an Access Database

Posted on 1997-06-16
2
Medium Priority
?
240 Views
Last Modified: 2013-12-25
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
0
Comment
Question by:edowney
2 Comments
 

Expert Comment

by:rpoffel
ID: 1854320
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
 

Accepted Solution

by:
JamesN earned 200 total points
ID: 1854321
It should be:

Set Conn = Server.CreateObject("ADODB.Connection")
                                                             ^^
James
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
Suggested Courses

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question