Devart Forums

Posted: **Tue 29 Nov 2011 12:14**

Hi,

We have implemented a .NET 4.0 C# ANY CPU application that uses Devart 6.50.250.0 to access an Oracle 11g database at another machine. The development machine is Windows 7 64-bit and has Oracle 11g Client 64-bit installed with a correct tnsnames.ora.

The connection string is NOT direct and of the following form:

Code: Select all

Persist Security Info=True;Server={0};User Id={1};Password={2};Direct=False;Sid={0};Unicode=true

When the code runs, the following exception

Code: Select all

System.Data.EntityException: The underlying provider failed on Open. ---> System.IO.FileNotFoundException: Can not load Oracle client library oci.dll from home .

The space before the . probably means that the HOME variable could not be retrieved, thus home is null.

Even though, the home is correctly set in registry and environmental variables.

In another development machine that is Windows 7 32-bit with Oracle 11g Client 32-bit, everything works as expected for the same application.

Any ideas?

Posted: **Wed 30 Nov 2011 13:04**

Make sure that the mode, in which your application is executed, corresponds to the capacity of your Oracle client (x64), because the application can be run under WoW64 in x64 systems. You can check the mode of your application in Windows Task Manager (the Processes tab).

Posted: **Wed 30 Nov 2011 13:50**

Thanks a lot, the problem was that I have been using VS Development Server that is 32-bit! From now on, I use local IIS

Devart Forums

dotConnect for Oracle cannot find OraHOME

dotConnect for Oracle cannot find OraHOME