oci.dll error

[sh3rIIf]

Hi

 

I'm trying to use a oracle connection in my vb.net web app, but get the following error message whenever i try to view the page:

 

 

Unable to load DLL (oci.dll).

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

 

Exception Details: System.DllNotFoundException: Unable to load DLL (oci.dll).

 

Source Error:

 

 

Line 215:

Line 216: DBConnection = New OracleConnection(ConnectString)

Line 217: DBConnection.Open()

Line 218:

Line 219: Return New dbDataReader(Source, DBConnection)

 

 

I'm obviously missing somethinbg from oracle but what do i need to install. i installed the entire oracle package on another machine and the dll was there, but i don't want to install the whole damn thing. i just want to install the stuff i need

[iebidan]

Well, is kind of amazing this, but for you tu be able to connect to an Oracle DB you need to have the Oracle client installed in your computer, install it and the problem will solve, remember to create the SID to the database

[sh3rIIf]

oracle client is installed already, that's why i'm so confused that the dll is missing.

[iebidan]

Well I can't think of other solution at this moment, I tried looking for information on Microsoft's KB, do the same, maybe you'll find it faster, but anyway if I find why you get this problem I¿'ll let you know, BTW, is the SID configured????

[iebidan]

Or if you can send me an example on what you're doing, maybe I can test it in my computer, I have an Oracle database, maybe with this I can find a solution faster

[davelilly]

I'm getting the same problem from my web service, but it connects fine from a windows application. The Oracle client is installed fine, the correct oci.dll veriosn is in the oracle home\bin directory, but I get System.DllNotFoundException: Unable to load DLL (oci.dll) when trying to open the connection.

 

Have you guys had any success?

 

Cheers.

[sh3rIIf]

i re-installed the entire oracle client package in mine worked after that

[davelilly]

:)

 

Solved my occurance of the problem by making the ASPNET user a member of the Administrators group. Not a perfect solution, but at least I know it was user access related. (Reboot required after change).

 

Cheers,

D.

[Daspoo]

Extra Info...

 

Found this post to a forum on http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=55571 :

 

==================================

"This can be caused by the ASPNET user account (or whatever account the server is running under) not having access to the Oracle bin directory. By default, this directory is only accessible to the user who installed Oracle and the Administrators group. You need to grant read/execute permissions for that directory to the ASPNET user account for the server to be able to find OCI.DLL. "

===================================

 

Also, if you don't give the ASPNET account at least read and execute permissions to access not only the \bin directory, but the parent directory (Oracle_Home or \Ora92 or what have you) as well, you'll probably end up with an error like this...

 

"Unable to find entry point name OCIEnvCreate in DLL oci.dll"

 

Hope this all helps - considering I barely know what I'm talking about, too...:D

[e33zozo2000]

I installed the ODP.net package provider from oracle,then I can

use Oracle .NET Provider from Microsoft well.who can tell me why?