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 ?
Connecting to a db when using Oracle 11g 64 bit client
-
- Posts: 9
- Joined: Thu 16 Sep 2010 20:10
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).
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).
-
- Posts: 9
- Joined: Thu 16 Sep 2010 20:10
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 ?
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 ?
Re: Connecting to a db when using Oracle 11g 64 bit client
Has this issue been resolved? I still get this error when using Entity Developer.
Re: Connecting to a db when using Oracle 11g 64 bit client
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.