That Long and Winding Oracle 32/64 bit Road
Install the 32-bit
ODAC Component
(I did not install the
64-bit version of the ODAC, only the 32-bit Version)
Install the FULL
Oracle11 Clients for BOTH 32 and 64 bit
My tip: Install these
to two separate ORACLE_HOME (OraClient11g_home1 and OraClient11g_home2) and put
them in an easy identified folders like:
32-bit:
C:\Oracle\product\11.2.0\client_32\
64-bit:
C:\Oracle\product\11.2.0\client_64\
Make sure the
tnsnames.ora are updated in BOTH places:
C:\Oracle\product\11.2.0\client_32\Network\Admin\
C:\Oracle\product\11.2.0\client_64\Network\Admin\
Edit Registry keys to
make sure these all points to the correct Oracle (and not Microsoft) dll’s in C:\Windows\System32
HKLM\SOFTWARE\Microsoft\MSDTC\MTxOCI
+
HKLM\SOFTWARE\Wow6432Node\Microsoft\MSDTC\MTxOCI
OracleSqlLib – from
SQLLib80.dll to orasql11.dll
(32-bit file copied from 32-bit client)
OracleXaLib – from
xa80.dll to oraclient11.dll (32-bit file copied from
32-bit client)
(This only because the
supplied Microsoft Library only Supports Oracle up to version 8)
Test:
Create an empty text
file, and rename it test.udl
Now, open this file –
and view Providers:
Create ODBC Connection for both 32 and 64 bit and test:
Ref.