Oracle 8 client in Windows 7 64-bit
I just upgraded my pc to the 64-bit version of Windows 7.
I use an older application "Humingbird BI Query" to access an Oracle database, via SQLNet and the Oracle 8 client.
This works as long as I install the Hummingbird app in the 'Program Files' folder (instead of the 'Program Files (x86) folder).
The oracle client is installed in c:\oracle\ora81.
The TNS_ADMIN environment variable is pointed to c:\oracle\ora81\network\admin
c:\oracle\ora81\bin; is first in the PATH
ORACLE_HOME points to c:\oracle\ora81
I am using 32-bit Excel, and had created several ODC's to pull data into Excel pivots from this same Oracle db.
Problem: since migrating to the 64-bit OS, the 32-bit version of the MS ODBC driver pointed to in the old ODC's is no longer in the %WINDIR%\System32 folder. These are now in the %WINDIR%\SysWOW64 folder.
Running the ODBC Admin tool from the SysWOW64 directory, I can see the 'Oracle ODBC Driver' listed, but it doesn't have any version/company / date/ information like it isn't registered correctly. When I attempt to set up a DSN using the Oracle ODBC driver I get the error " The setup routines for the Oracle ODBC Driver ODBC driver could not be loaded due to system error code 126: The specified module could not be found. (%WINDIR%\system32\SQORAS32.DLL). (this dll is in the Ora81\bin folder)
It looks like the install of the Oracle 8 client did not set the registry correctly to point to the appropriate DLL's.?
Maybe the Oracle 8 client doesn't set itself up properly in Win7-64... not compatible with 64-bit OS?
I suppose I could install the latest 32-bit oracle client... but this was working fine with the older client while on the 32-bit OS.
Any assistance or direction would be appreciated.
Rich