Remote App/Client/tns

[GmoSF]

Using Oracle 9i, Oracle client 9.2 , Delphi7, DAO.

When a client runs a Delphi application connecting to a remote server is it possible to resolve (at run time) the location of the oci.dll, tnsnames.ora when these are on the server not on the client. The client is not able to load the oracle/client on their local drive. If so how?

Hope the question is not to vague.

 

[Marco Kalter]

The Oracle registry on the local machine will need to match the location of the Oracle installation. It can be located on a (Windows) server though.

If there is no Oracle registry on the local machne, you can also set the ORACLE_HOME environment variable to the Oracle Home directory.

 

[GmoSF]

Thanks for your help Marco,

Got further but now if I run the app on my machine passing the string parms :
\\C-c45-abc01\TestApp\Test\Project1.exe ocidll=\\C-c45-abc01\oracle\ora92\bin\oci.dll oraclehome=OraHome92

the app connects fine \\C-c45-abc01 being my local machine but when I run from a different machine using the same connection string the app runs but when I log on (using TOracleLogon) a blank message box pops up. Am only using OracleSession

 

[GmoSF]

Just to add I think the message box might be to say that it cannot resolve the TNS: could not resolve service name.

 

[Marco Kalter]

A blank message box is not really helpful. Does the other machine have an Oracle registry?

You could consider using the Oracle10g Instant Client. It seems more suitable for this purpose.