We have just switched from Win2003 32bit to Win2003 R2 64bit for an old application, we have mirrored the setup including Oracle client 9 that connects to Oracle databases. TNSNAMES is local and lookup is in the reg plus I've set it up as a variable on the Windows server.
I've installed the instantclient-x64-11.2.0.1 and the instantclient-ODBC-11.2.0.1 client on this server and get the following errors using various connection strings
dbDatabase.ConnectionString = "DSN=PRD23;Uid=test;Pwd=test"
tried this on a Windows 7 PC using the same instantclient and this works fine, try it on the server and get the error.....
dbDatabase.ConnectionString="Driver={Oracle in instantclient_11_2};Uid=test;Pwd=test"
error: 800A0EA9 provider is not specified and there is no designated default provider
source: ADODB.connection
dbDatabase.ConnectionString="Provider=SQORA32.dll;Database=PRD23;Uid=test;Pwd=test"
error: 800A0E7A provider cannot be found, it may not be properly installed
source: ADODB.connection
dbDatabase.ConnectionString="Driver={Oracle in instantclient_11_2};Provider=SQORA32.dll;Uid=test;Pwd=test"
error: 800A0E7A provider cannot be found, it may not be properly installed
source: ADODB.connection
any suggestions ?