Find the right Oracle Client for both x86 and x64.
Posted: Thu 25 Nov 2010 10:36
Hi,
On a system with 32 bit 11g oracle client AND 64 bit 11g oracle client installed (using different homes) it is possible to run assemblies in x86 or x64 Mode on the same system, both connecting to an oracle database.
For that the ADO.Net provider does have to find the right oracle client. System.Data.OracleClient can do that. I guess its looking the oracle home up in the registry and is automatically redirected to the Wow6432Node when running in 32 bit mode. The 'wrong' way would be to depend on environment variables like PATH which are the same for 32 and 64bit applications.
dotConnect for Oracle 5.70.190.0 does only find the client that has been installed last, so i assume its using the environment variables.
It would be really helpful if you could implement a better oracle client lookup for systems with both 32 and 64 bit oracle clients installed.
Thanks and with kind regards
Bernhard
On a system with 32 bit 11g oracle client AND 64 bit 11g oracle client installed (using different homes) it is possible to run assemblies in x86 or x64 Mode on the same system, both connecting to an oracle database.
For that the ADO.Net provider does have to find the right oracle client. System.Data.OracleClient can do that. I guess its looking the oracle home up in the registry and is automatically redirected to the Wow6432Node when running in 32 bit mode. The 'wrong' way would be to depend on environment variables like PATH which are the same for 32 and 64bit applications.
dotConnect for Oracle 5.70.190.0 does only find the client that has been installed last, so i assume its using the environment variables.
It would be really helpful if you could implement a better oracle client lookup for systems with both 32 and 64 bit oracle clients installed.
Thanks and with kind regards
Bernhard