Unable to find an entry point named OCIEnvCreate in DLL oci.dll.

  • Thread starter Thread starter Sebastián_UY
  • Start date Start date
S

Sebastián_UY

Does anybody know why is that going on???
It works fine in development but not in production, figures.

TIA

Microsoft Oracle Data Provider
 
¤ Unable to find an entry point named OCIEnvCreate in DLL oci.dll.

Is this an ASP.NET app or a VB.NET, C# app?

If it is an ASP.NET application it is probably a security permissions problem on the bin directory
of the Oracle installation.

Also make certain that you have only one version of the Oracle client installed. I believe that at
least 8.1.7 is required for the Microsoft Oracle Provider for .NET and 9i is required for Oracle's
Data Provider for .NET.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Thanks Paul.
It is a win VB.Net app with only one Oracle installed but it's 8.0.5.0.0

What are my options????

Thanks again!

--
Ing. Sebastián Gómez Correa
----------------------------------------------
(e-mail address removed)
Poder Judicial - División Tecnología
Montevideo - URUGUAY
----------------------------------------------------------------------------
----------------------
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
----------------------------------------------------------------------------
----------------------
 
Hi,

Paul is absolutely right.
Check/Set NTFS permission for aspnet local windows account on Oracle folder
and subfolders.
 
Install at least Oracle 8.1.7 version (client).

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Sebastián_UY said:
Thanks Paul.
It is a win VB.Net app with only one Oracle installed but it's 8.0.5.0.0

What are my options????

Thanks again!

--
Ing. Sebastián Gómez Correa
----------------------------------------------
(e-mail address removed)
Poder Judicial - División Tecnología
Montevideo - URUGUAY
-------------------------------------------------------------------------- --
Click to expand...
 
Thanks Miha, but that's not one of my options.
I have to solve it with the existing environment.

What about ODBC, could I use that????

--
Ing. Sebastián Gómez Correa
----------------------------------------------
(e-mail address removed)
Poder Judicial - División Tecnología
Montevideo - URUGUAY
----------------------------------------------------------------------------
----------------------
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
----------------------------------------------------------------------------
----------------------
Miha Markic said:
Install at least Oracle 8.1.7 version (client).
Click to expand...
 
Hi,

Sure, if it works for you, why not.
It won't be that efficient and could have some problems here and
there...(haven't tried it) - I suggest you to do the tests by yourself.
You might even try OleDb provider.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Sebastián_UY said:
Thanks Miha, but that's not one of my options.
I have to solve it with the existing environment.

What about ODBC, could I use that????

--
Ing. Sebastián Gómez Correa
----------------------------------------------
(e-mail address removed)
Poder Judicial - División Tecnología
Montevideo - URUGUAY
-------------------------------------------------------------------------- --
Click to expand...
--
 
Ok, thanks.
I kinda lost!, could you show me some links on how to work with ODBC and
OleDB?

TIA!
 
¤ Ok, thanks.
¤ I kinda lost!, could you show me some links on how to work with ODBC and
¤ OleDB?

Here is an example using the OLEDB provider for .NET:

Dim DatabaseConnection As New System.Data.OleDb.OleDbConnection

DatabaseConnection.ConnectionString = "Provider=MSDAORA;" & _
"Data Source=ServerName;" & _
"USER ID=UserID;PASSWORD=password;"

DatabaseConnection.Open()

'...
'...

DatabaseConnection.Close()

Here is an example using the ODBC Provider for .NET:

Dim ODBCConnection As New Microsoft.Data.Odbc.OdbcConnection

ODBCConnection.ConnectionString = "DRIVER={Microsoft ODBC for Oracle};" & _
"SERVER=ServerName;" & _
"UID=UserID;PWD=password;"

ODBCConnection.Open()

'...
'...

ODBCConnection.Close()

In addition, if you choose the Microsoft ODBC Provider for .NET, the library was not included with
VS 2002 so if you are using that version you will need to download and install the library:

http://www.microsoft.com/downloads/...27-1017-4f33-a062-d165078e32b1&displaylang=en


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Thanks Paul.
You've been a great help!

--
Ing. Sebastián Gómez Correa
----------------------------------------------
(e-mail address removed)
Poder Judicial - División Tecnología
Montevideo - URUGUAY
----------------------------------------------------------------------------
----------------------
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
----------------------------------------------------------------------------
----------------------
 
Oh boy, good think you guys had this discussion, else I would've been
struggling to get my C# code
to work with the Oracle 8.0.6 client installed. I installed Oracle 9.2.0
client and all works well for now :)

Thanks a bunch

Pir8

Miha Markic said:
Install at least Oracle 8.1.7 version (client).
Click to expand...
 
Back
Top