ISSUE:
I receive the following error on our Win2003 64 bit and SQL Server 2005 64 bit system:
ADODB.Connection error '800a0ea9'
"Provider not specified and there is no designated default provider"
CAUSE:
This occurs because there is no 64 bit version of MSDASQL.DLL which is the OLEDB provider for ODBC drivers. If you want to to connect using a 64 bit system you need to use an OLEDB provider, in SQL server case it will be SQLOLEDB.
SOLUTION:
You will need to modify shop$db.asp.
Around line 20 locate:
const xsqloledb="No" ' use SQL Server standard
Change this to:
const xsqloledb="Yes" ' use SQL Server standard
Note: "Yes" must appear in that exact case fashion with the first letter capitalized.
ALSO:
If the above does not work, it is possible to run IIS in 32 bit mode. So it can use all the database drivers
Please see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;894435
says to execute:
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1