Solved

ASP access to an Access Database

Posted on 1997-06-16
2
224 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Suggested Solutions

Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
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…
The viewer will learn how to dynamically set the form action using jQuery.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

734 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