Devart Forums

Hi,
We are using UNIDirect components to connect our web service to Oracle database. CoreLab.Unidirect.dll version is 2.5.7.0.
When we install the web service on the client computer, we keep all required DLLs in the BIN folder of the compiled service. Oracle Client always is installed before we create the web service.
Yesterday we got an error on the client side: "Can not find ORACLE HOME".
1. Client system: XP
2. Oracle client: several of them, starting 7.2 and higher

How can we fix the problem without reinstalling all Oracle Clients on the client computer?

Thank you.

1. a) Are you using "Provider=Oracle;" or "Provider=OracleClient" connection string parameter?
b) dotConnect Universal is a wrapper of dotConnect Oracle (the "Provider=Oracle;" case). The version of dotConnect for Oracle that corresponds to CoreLab.Unidirect.dll v 2.5.7 supports both x86 and x64 versions of the following Oracle clients: 10g, 9i, 8i and 8.0.
What version of Oracle Client is used on your client workstation?
2. Make sure that your application has capacity that corresponds to the capacity of your Oracle client (32-bit or 64-bit).
3. Please check that the Path system variable contains the path to the Oracle client location. Try setting Oracle client's path at the first place in Path.
4. Make sure that Oracle client is valid. Try connecting using it with any other tool.

We update Path system variable, but it didn't work. Do we need to restart any other services after update? Refresh something to force UniDirect to see the path?

1.

gala_l wrote:We update Path system variable, but it didn't work. Do we need to restart any other services after update? Refresh something to force UniDirect to see the path?

Restarting web serivce that uses dotConnect Universal should be enough. For sure, restart your client computer if possible.
2. Please answer the question we have asked in the previous post.
3. Refer to this thread. Does it help?

We are using: "Provider=Oracle;"

Finally it started to work, but we are not sure what exactly helped.
1. We updated Oracle Home path. Didn't help.
2. Rerun the iis. Didn't help.
3. Client administrator did something somewhere without explanation and application started to work.

I'd like to know what else need to be done in this situation, if we will run in it with other client.

I also will keep an eye on other thread, to see, how it will work out.

Please contact your client administrator to clarify what he actually did to make it work.

A common reasons for this error we have already mentioned in this thread (workability of Oracle client, matching capacities of Oracle client and the process of your application, the first position of the path to Oracle home in the system variable Path).

Your feedback concerning the reason of the "Can not find Oracle Home" error in your case will be appreciated.