dotConnect for Oracle cannot find OraHOME

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
GrMikeD
Posts: 22
Joined: Tue 10 Nov 2009 20:24

dotConnect for Oracle cannot find OraHOME

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

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

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

GrMikeD
Posts: 22
Joined: Tue 10 Nov 2009 20:24

Post by GrMikeD » 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

Post Reply