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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
meetkarthik
Posts: 9
Joined: Thu 16 Sep 2010 20:10

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

Post by 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 ?

Shalex
Devart Team
Posts: 8072
Joined: Thu 14 Aug 2008 12:44

Post by 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).

meetkarthik
Posts: 9
Joined: Thu 16 Sep 2010 20:10

Post by 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 ?

Shalex
Devart Team
Posts: 8072
Joined: Thu 14 Aug 2008 12:44

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

Post by 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.

graci
Posts: 1
Joined: Wed 02 Jan 2013 14:46

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

Post by graci » Wed 02 Jan 2013 14:48

Has this issue been resolved? I still get this error when using Entity Developer.

Shalex
Devart Team
Posts: 8072
Joined: Thu 14 Aug 2008 12:44

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

Post by 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/3867 ... -developer.

Post Reply