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

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

Postby 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
welton
 
Posts: 4
Joined: Thu 08 Jul 2010 18:13

Postby 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.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44

Postby susahin80 » Wed 12 Oct 2011 12:55

Is there any news about this issue?
susahin80
 
Posts: 4
Joined: Tue 09 Aug 2011 15:57

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: 7839
Joined: Thu 14 Aug 2008 12:44

Postby susahin80 » Thu 13 Oct 2011 07:43

Great news.
susahin80
 
Posts: 4
Joined: Tue 09 Aug 2011 15:57

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: 7839
Joined: Thu 14 Aug 2008 12:44

Postby gregor » Sun 13 Nov 2011 17:00

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

Gregor
gregor
 
Posts: 10
Joined: Sat 25 Dec 2010 15:55

Postby 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.
Duke
Devart Team
 
Posts: 476
Joined: Fri 29 Oct 2004 09:25


Return to dotConnect for Oracle