I`ve been browsing the forums for a while and I saw several people with the same problem, but so far I haven`t been succesful with any of them. So I`m gonna give it a try myself:
I created a Windows Service in VB.NET which is supposed to move files across the network and access a database. Although it works on my own computer and on several other test PCs, strangely enough it doesn`t run on the PCs where it is supposed to run.
I`ve tried to track down all kinds of differences, but so far I have only come to a few conclusions on the PC where it doesn`t work:
- There is no Oracle Client installed on the local PC; they all run their stuff from the network.
- They have a Novell network, although the Service runs on a Windows PC in that same network. There is a Novell Client installed on that PC to communicate with the Novell Server.
I`m using Framework 1.1, Windows XP as Windows PC and Novell Netware 3.5. Furthermore, there is both an Oracle Client 8.1.7 and Oracle 7 client available on the network (but I checked the registry and they both point to the 8.1.7 client).
At first I thought the Windows PC wouldn`t be able to communicate across the Novell network, but apparently the Novell Client suffices.
Is it mandatory to have an Oracle Client locally installed on the PC or should it be able to work across the network?
Are there tricks which I ought to know when it comes to communicating across a Novell network?
This is the error I get:
24-10-2005 14:48:56 Could not access database.
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 WindowsService4.clsKoppeling.iniOmgeving()
24-10-2005 14:48:56 Could not start application.