Find the right Oracle Client for both x86 and x64.

Find the right Oracle Client for both x86 and x64.

Postby bernhard.klefer » 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
bernhard.klefer
 
Posts: 5
Joined: Wed 24 Nov 2010 14:52

Postby StanislavK » Thu 25 Nov 2010 16:26

Thank you for your suggestion, we will analyze the possibility of filtering Oracle clients depending on their capacity. We will inform you about the results here.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby bernhard.klefer » Wed 08 Dec 2010 11:47

I've just found a that if you assign a Oracle home name to the OracleConnection.Home property, the connection will choose the right version, even if a home with the same name exists in both x86 and x64.

So its something like this:
Code: Select all
var oracleKey = Microsoft.Win32.Registry.LocalMachine.OpenSubKey("SOFTWARE").OpenSubKey("ORACLE");
string home = (string)oracleKey.OpenSubKey(oracleKey.GetSubKeyNames()[0]).GetValue("ORACLE_HOME_NAME");

connection.Home=home;
connection.Open();


This is a useful workaround for the time being.

Bernhard.
bernhard.klefer
 
Posts: 5
Joined: Wed 24 Nov 2010 14:52

Postby Shalex » Thu 13 Oct 2011 07:26

The bug with filtering Oracle clients depending on their capacity is fixed. We will post here when the corresponding build of dotConnect for Oracle is avilable for download.
Shalex
Devart Team
 
Posts: 7824
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Tue 25 Oct 2011 07:47

New build of dotConnect for Oracle 6.50.237 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=22379 .
Shalex
Devart Team
 
Posts: 7824
Joined: Thu 14 Aug 2008 12:44

Postby hazel10 » Tue 01 Nov 2011 12:39

Thanks for letting us know Pondok Cerita about this useful stuff!
hazel10
 
Posts: 1
Joined: Tue 01 Nov 2011 12:35


Return to dotConnect for Oracle