Devart Forums

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

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.

Is there any news about this issue?

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.

Great news.

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 .

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

Gregor

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.