Re: [aus-dotnet] System.DllNotFoundException: Unable to load DLL (oci.dll).

[Eddie de Bear]

ahh.. I love this error..

It actually has to do with security. Check the account that the web
service is running under has access to the directory that contains
oci.dll (for me it's c:\oracle\ora92\bin\oci.dll)

I think you can also modify Machine.Config and change the identity
that IIS uses from machine to SYSTEM

Also, make sure you have rebooted the machine after installing the
oracle client.. This is another possibility as it uses the PATH
environment variable to find the dll.. Funilly enough, this update
does not happen until the first logon after the oracle client
install..

I hope this helps..



On Wed, 1 Dec 2004 15:50:43 +0800, Hordern, Chris (Hordern Cons. at
Alcoa) <chris.hordern@xxxxxxxxxxxx> wrote:
> 
> 
> I've got a webservice that runs successfully on the development machine and
> is now deployed to a Windows 2003 Server. The webservice connects to a
> Oracle 9i database. The Oracle client has been installed on the server and
> using sql plus it connect fine to the relevant database.
> 
> When we run the test connection method in the webservice the following error
> occurs 
> 
> System.DllNotFoundException: Unable to load DLL (oci.dll). 
>    at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject,
> Boolean& isInTransaction) 
>    at
> System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String
> encryptedConnectionString, OracleConnectionString options, OracleConnection
> owningObject, Boolean& isInTransaction)
> 
>    at
> System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString
> parsedConnectionString, Object transact)
> 
>    at System.Data.OracleClient.OracleConnection.Open() 
>    at PODSECLoadWS.DataLoadBR.TestConnection() in
> C:\Projects\PODS\PODSECLoadWS\DataLoadBR.vb:line 223 
>    at PODSECLoadWS.DataLoadWS.TestConnection() in
> C:\Projects\PODS\PODSECLoadWS\DataLoadWS.asmx.vb:line 67 
> 
> Any ideas. I ran filedomon.exe and could not see any ACCESSS DENIED messages
> so it appears permissions are ok. 
> 
> Any ideas?? 
> 
> and yes I hate Oracle 
> 
> ________________________________ 
> 
> CHRIS HORDERN 
> HORDERN CONSULTING AT ALCOA 
> PH. 03 5245 1323 
> MOB. 0418 543220 
> EMAIL: chris.hordern@xxxxxxxxxxxx 
> ________________________________ 


-- 
Cheers

Eddie de Bear
_________________
You are a part of the Australian "dotnet" mailing list.
To unsubscribe send "unsubscribe dotnet" or to re-subscribe send "subscribe dotnet Your Name" in the body of the email to: imailsrv@xxxxxxxxxxx
List managed by: http://www.stanski.com