Oracle 32 bit vs. 64 bit client order in environment path...

welton · Post by **welton** » Wed 06 Apr 2011 19:01

I am receiving the following error when attempting to create a Data Connection in Visual Studio when my 64 bit Oracle client precedes my 32 bit Oracle client in my Computer->Environment Variables->System variables->Path.

Error message:

---------------------------
Microsoft Visual Studio
---------------------------
Unable to load C:\Oracle\Ora11R2Cl64\bin\oci.dll. Please check that you use 32x version of Oracle client with 32x application.
---------------------------
OK
---------------------------

Path fragment:

C:\Oracle\Ora11R2Cl64\bin;C:\Oracle\Ora11R2Cl32\bin;

I can switch the order of the clients in the path, but then I get the same problem when trying to connect with a 64 bit app.

This becomes a real issue when I have to run 32 bit and 64 bit applications.

Is this a Visual Studio issue, or a Devart data connection issue? Can't the Devart connection component search the entire path for the correct version of the Oracle client?

TIA,
Welton

Shalex · Post by **Shalex** » Fri 08 Apr 2011 09:09

This is a known issue. We are investigating it. I will post here about the results.

As a workaround, please try the following:
1. If your x86 and x64 OracleHomes have different names, set explicitly the "Home" connection string parameter. If it doesn't help or your OracleHomes have the same name, try the point 2.
2. Try the workaround that is mentioned at http://www.devart.com/forums/viewtopic.php?t=19587.

Please notify us about the results.

susahin80 · Post by **susahin80** » Wed 12 Oct 2011 12:55

Is there any news about this issue?

Shalex · Post by **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.

susahin80 · Post by **susahin80** » Thu 13 Oct 2011 07:43

Great news.

Shalex · Post by **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 .

gregor · Post by **gregor** » Sun 13 Nov 2011 17:00

Same problem is with dbforge. fbForge cannot connect on x64 windows. Direct mode is working ok...

Gregor

Duke · Post by **Duke** » Mon 14 Nov 2011 08:50

gregor wrote:Same problem is with dbforge. fbForge cannot connect on x64 windows. Direct mode is working ok...
Gregor

If you mean dbForge Studio for Oracle, we are aware of this problem and working over it. As a workaround you can install 32-bit Oracle client.