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!