Could not load oci.dll

[manielan]

Hi There,
1. I'm using DOA 3.4.5 with Delphi 5 Ent updatepack 1.
2. My oracle client is physically in the server and my registry entry is accoring to the location via map drive. (H:\..\..) oci.dll ver is 8.0.5.0.1

According my DBA, this setting works for other programs.

3. Now, when I try to connect (both run & design) I have an error message.

Error Msg is
OracleHomeKey : software\oracle\Home0
OrcleHomeDir : ..\orawin95
Found : oci.dll, ora73.dll, ora803.dll, ora804.dll, ora805.dll
Using : ..\bin\oci.dll
LoadLibrary(..\bin\oci.dll) returned 0.

Any help to solve the issue?
TIA.
-Mani

 

[Marco Kalter]

Apparently this OCI.DLL cannot be loaded.

Is this \bin directory listed first in the PATH? If not, can you make it so and try again?

If this does not help, perhaps you can temporarily rename OCI.DLL so that Direct Oracle Access will use ora805.dll?

------------------
Marco Kalter
Allround Automations

 

[manielan]

Is it true that, You must have the Oracle client installed on the workstation for DOA to work?

Because in my deployment environment, files are in a sever's shared dir and client's software\Oracle key in the registry is set accordingly.

Anyone to clarify?
Thanks
Elan

 

[Marco Kalter]

The Oracle Client software can be installed on a file server, but the Oracle registry (hkey_local_machine\software\oracle) and the PATH environment variable must be set accordingly on the client PC.

------------------
Marco Kalter
Allround Automations

 

[manielan]

Oracle registry and the PATH environment variable are set accordingly and infact other Oracle applications are working well. To prove that I changed the DOA connection to ADO and it works perfectly. Any Idea?

-Mani