The infamous oci.dll
-
- Posts: 8
- Joined: Fri 08 May 2009 19:15
The infamous oci.dll
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 !
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 !
check the system path
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\
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\
-
- Posts: 8
- Joined: Fri 08 May 2009 19:15
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.
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.
-
- Posts: 8
- Joined: Fri 08 May 2009 19:15
-
- Posts: 8
- Joined: Fri 08 May 2009 19:15
-
- Posts: 8
- Joined: Fri 08 May 2009 19:15
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.
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.
-
- Posts: 8
- Joined: Fri 08 May 2009 19:15