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

x
?
Solved

ADODB.Connection error '800a0ea9' Active Server Pages

Posted on 2009-07-08
2
Medium Priority
?
1,233 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!
0
Comment
Question by:aaron63
2 Comments
 
LVL 6

Accepted Solution

by:
ahmad2121 earned 1500 total points
ID: 24809517
0
 
LVL 1

Author Closing Comment

by:aaron63
ID: 31601380
Thank you! I feel like a fricken idiot. That worked great. I wish they had just kept the original, however.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Screencast - Getting to Know the Pipeline
Suggested Courses

772 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