Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 8 client in Windows 7 64-bit

rdarlin2Jul 9 2012 — edited Jul 18 2013
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 15 2013
Added on Jul 9 2012
23 comments
43,999 views