DOA Connection on Oracle 10g Server

[RichHP]

Hi,

We have a piece of software using DOA 4.1.2.2, which is running on a machine with an installation of Oracle 10g XE. We're finding that the software using DOA is not resolving the database name, however TNSPing works and SQL Plus can connect.

The ORACLE_HOME enviroment variable is set to c:\oraclexe\app\oracle\product\10.2.0\server\. The OCI.DLL is in the BIN directory off the Oracle home root.

Any suggestions as to what the problem is?

Many thanks,

Rich.

 

[RichHP]

Solved this, it was the known issue of having brackets in the path of the .exe trying to access the Oracle client.