The infamous oci.dll

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
ultraman69
Posts: 8
Joined: Fri 08 May 2009 19:15

The infamous oci.dll

Post by ultraman69 » Fri 08 May 2009 19:23

Hi !

I'm trying to create an entity model from an Oracle database but I always get the "Can not load oci.dll from home OraClient11g". I googled my way through some solution but nothing seems to work. My Environment variable seems to be set OK (ORACLE_HOME and PATH contains the path to my Oracle11g client) and the oci.dll is there. So what point am I missing here ???

Any help would be really appreciated.
Thanks !

estern
Posts: 19
Joined: Tue 27 Jan 2009 18:59

check the system path

Post by estern » Sun 10 May 2009 16:14

start, settings, control panel, system
advanced tab
environment variables button
system variables, path

mine looks like this
C:\oracle\product\10.2.0\db_1\bin;C:\oracle\product\10.2.0\client_1\bin;C:\oracle\product\10.2.0\client_2\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\

ultraman69
Posts: 8
Joined: Fri 08 May 2009 19:15

Post by ultraman69 » Mon 11 May 2009 14:34

My environment variable (Path) points to the dir where Oracle 11g is installed (C:\lgc\OraCli11g\client1\BIN) and the oci.dll is there.

My ORACLE_HOME also points there in both in the registry AND the environment variable.... but still, nothing works... :(

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 12 May 2009 15:54

Ultraman69, please check the home.Path property of the OracleConnection.Homes collection.
For example, OracleConnection.Homes["OraClient11g_home"].Path;

What is the content of this home.Path? There should be oci.dll on this path
at your hard drive (home.Path+"\bin\oci.dll" or home.Path+"\oci.dll"). Check if it exists.

Please notify us about the results.

ultraman69
Posts: 8
Joined: Fri 08 May 2009 19:15

Post by ultraman69 » Tue 12 May 2009 17:04

I'm sorry but I really don't know what you're talking about. What is the "OracleConnection.Homes collection" ??? Where is it, in the registry ?

ultraman69
Posts: 8
Joined: Fri 08 May 2009 19:15

Post by ultraman69 » Tue 12 May 2009 17:19

Ok, I found it, I ran a sample project and tested the connection, sorry.

The OracleConnection.Homes["OraClient11g"].Path ="C:\lgc\OraCli11g\client1"

And if I look in my this directory, the oci.dll is in the "\BIN" (uppercase) folder.

ultraman69
Posts: 8
Joined: Fri 08 May 2009 19:15

Post by ultraman69 » Tue 12 May 2009 17:32

I think I might have found something. In the OracleConnection.Homes collection, It seems like I have 2 Homes with the same Name. 1 with nothing set and the other with everything OK.

OracleConnection.Homes[0].Name="OraClient11g"
OracleConnection.Homes[0].NlsLang=""
OracleConnection.Homes[0].Path=""

OracleConnection.Homes[1].Name="OraClient11g"
OracleConnection.Homes[0].NlsLang="FRENCH_AMERICA.WE8ISO8859P1"
OracleConnection.Homes[0].Path="C:\lgc\OraCli11g\client1"

And if I check OracleConnection.Homes["OraClient11g"], it points to the first one with nothing. But the OracleConnection.Homes.DefaultHome points to the good one.

ultraman69
Posts: 8
Joined: Fri 08 May 2009 19:15

Post by ultraman69 » Tue 12 May 2009 18:59

I finally managed to make it work by deleting the other "OraClient11g" entry in the registry.


Thanks !

Post Reply