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

[Mitch Wheat]

Hi Chris

It's a stab in the dark really (but coincidently, my colleagues were having 
a similar problem): have you tried using the Oracle provider instead of the 
Microsoft supplied one?
Mitch

----- Original Message ----- 
From: "Hordern, Chris (Hordern Cons. at Alcoa)" <Chris.Hordern@xxxxxxxxxxxx>
To: <dotnet@xxxxxxxxxxx>
Sent: Wednesday, December 01, 2004 3:50 PM
Subject: [aus-dotnet] System.DllNotFoundException: Unable to load DLL 
(oci.dll).
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(OracleConnectionS
tring 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
________________________________


_________________
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