Solved

ADODB.Connection error '800a0ea9' Active Server Pages

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Lync server 2013 or Skype for business Backup Service Error ID 4049 – After File Share Migration
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include tâ€Ĥ

867 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now