Devart Forums

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 ?

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

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 ?

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.

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.

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

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.