Solved

ASP access to an Access Database

Posted on 1997-06-16
2
211 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 100 total points
ID: 1854321
It should be:

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

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
The viewer will learn how to dynamically set the form action using jQuery.
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.

832 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