Solved

ADODB.Connection error '800a0ea9' Active Server Pages

Posted on 2009-07-08
2
1,206 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 375 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Lync server 2013 or Skype for business Backup Service Error ID 4049 – After File Share Migration
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

776 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