Connecting to a db when using Oracle 11g 64 bit client

Connecting to a db when using Oracle 11g 64 bit client

Postby meetkarthik » Thu 16 Sep 2010 20:23

Hi,
I have a oracle 11g database and i am connecting using the 64bit client. When i try to create a LinqConnect/EF model and try to create the model from the database, i am not able to connect to any of the databases mentioned in the TNS. The only way i can overcome this is by using the 'direct' connection option.

But when i uninstalled the 64bit version and install the 32bit client, it works fine.

From the code, when i try to pass a connection string with the usual UserId-Password-Data Source format, i get the following exception. The problem is once again resolved if i use the 'direct' connection string.

"Unable to load C:\Oracle\Product\11.2.0\client-1\bin\oci.dll. Please check the 32x version of Oracle client with 32x application".

Am i doing anything wrong ?
meetkarthik
 
Posts: 9
Joined: Thu 16 Sep 2010 20:10

Postby Shalex » Fri 17 Sep 2010 09:22

The mode (capacity) of an application that uses Oracle Client should be the same as the mode of Oracle Client. If your your application (e.g., a process of VS) is a 32 bit one, Oracle client should be a 32 bit one as well. You can find the mode of the processes via Windows Task Manager.

Direct Mode doesn't use Oracle Client.

We compile our assemblies with the "any CPU" platform target. So, they can be used in the x86 and x64 modes (depends on the capacity of your application).
Shalex
Devart Team
 
Posts: 7705
Joined: Thu 14 Aug 2008 12:44

Postby meetkarthik » Fri 17 Sep 2010 21:43

Thanks. I found the root cause of this issue.

Visual Studio 2010 is right now available only in 32bit flavor. As a result of this, during design time, when i am trying to create the model , i am not able to connect the database using the TNS name.

And when i launch 'Entity Developer' directly from Devart dotConnect for Oracle -> Entity Manager , it always launches in 32bit mode.

Is there a fix for this in the v6 beta ?
meetkarthik
 
Posts: 9
Joined: Thu 16 Sep 2010 20:10

Postby Shalex » Mon 20 Sep 2010 12:01

We will investigate the issue why Entity Developer is launched as a 32bit process in the x64 environment and notify you about the results as soon as possible.
Shalex
Devart Team
 
Posts: 7705
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Mon 20 Sep 2010 13:52

Please use Entity Developer for the Direct connections (without Oracle Client) or with a 32-bit Oracle Client. Currently, we cannot support Oracle Client x64 in Entity Developer because the model's layout crashes if Entity Developer is launched as a 64-bit process.
Shalex
Devart Team
 
Posts: 7705
Joined: Thu 14 Aug 2008 12:44

Re: Connecting to a db when using Oracle 11g 64 bit client

Postby graci » Wed 02 Jan 2013 14:48

Has this issue been resolved? I still get this error when using Entity Developer.
graci
 
Posts: 1
Joined: Wed 02 Jan 2013 14:46

Re: Connecting to a db when using Oracle 11g 64 bit client

Postby Shalex » Thu 03 Jan 2013 10:51

Entity Developer does not work as a 64-bit process. Please post your suggestion to implement this functionality at http://devart.uservoice.com/forums/38671-entity-developer.
Shalex
Devart Team
 
Posts: 7705
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle