dotConnect for Oracle cannot find OraHOME

[GrMikeD]

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?

[Pinturiccio]

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

[GrMikeD]

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