IIS 6 won't start webpage

[GreenICT]

Getting error starting an ASP page:

 

ADODB.Connection error '800a0e7a'

 

Provider cannot be found. It may not be properly installed.

 

/dinners/index.asp, line 44

Line referred to is:

objconn.open session("strconn")

 

Following lines (if this helps!)are:

set objRS = server.createobject("ADODB.recordset")

set objRS.activeconnection = objConn

 

This has been moved from a 32bit Windows 2003 server to a 64bit one. All the suggestions I've found anywhere don't seem to work (Some turned out to be for IIS 7).

 

ANY suggestions appreciated as I'm no expert on IIS and ASP (rather a novice in fact!!)

[theriver]

Your ASP page is trying to connect to a data source, but either there's a problem with the connection library it's trying to use, or it's not installed on the new server.

 

Do you know what the connection string is? This will tell you what provider it's trying to use.

[mac_shinobi]

Your ASP page is trying to connect to a data source, but either there's a problem with the connection library it's trying to use, or it's not installed on the new server.

 

Do you know what the connection string is? This will tell you what provider it's trying to use.

 

We could do with seeing more of the code from the ASP page as per above in relation to the connection string, also what data source or database is it that you are using ie access 2003, access 2007, 2010, SQL, MySQL or what exactly ??

 

So Server 2003 64 bit and what version of IIS ? IIS 6 or 7 ?

 

I did find the below but not sure if you have already come across this in your googling / searching

 

http://stackoverflow.com/questions/3590546/adodb-connection-error-800a0e7a

 

In regards to connection string -->

 

http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040200/80040514/800a0e7a-errors.html

Edited July 10, 2012 by mac_shinobi