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

[Hordern, Chris \(Hordern Cons. at Alcoa\)]

Title: 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(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
________________________________