We help IT Professionals succeed at work.

ADODB.Connection error '800a0ea9' Active Server Pages

aaron63
aaron63 asked
on
Medium Priority
1,289 Views
Last Modified: 2012-06-27
There are similar threads to my problem, but I didn't see a solution that worked for me.

Background: We have a Web Application we use internally on a NT 4 box with IIS and SQL Server. Years ago I programmed a web application in Active Server Pages to access and collate this data into reports. Worked great for us for years and years. Note we are a relatively small office and I am not an IT guy. But I have an engineering degree, did a lot of reading, and was able to piece it all together.

Fast forward to the present. The NT 4 box is on its last leg so we upgraded to a Win Server 2003 with SQL 2005. Brought all the data over and got IIS set up. Started trying to run the application and here is the error I get and code:

ADODB.Connection error '800a0ae9'

Provider is not specified and there is no designated default provider.

The code that errors is as follows: Conn.Open "linksconn", "sa", "password"

I setup the System DSN for 'linksconn' in the ODBC Data Source Administrator on the new server and it works fine if you test it in ODBC Data Source Administrator (just like on the NT 4 box).

Reading up on this I can no longer use a DSN connection so the code will no longer work. My question is what code do I use to replace it? Also does anyone have the a book recommendation to help me navigate this upgrade? I built the application using 'Unlocking Active Server Pages', but obviously much of that code is out of date.

Thanks for any help!
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you! I feel like a fricken idiot. That worked great. I wish they had just kept the original, however.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.