New 10g Instant Client support

[sergio.sette]

Hi Marco,

does DOA works with the new 10g Instant Client

Best regards

sergio sette

 

[Marco Kalter]

Yes, the 4.0 version is compatible with the 10g Instant Client. The 3.4 version will not detect an Instant Client.

 

[sergio.sette]

Yes, the 4.0 version is compatible with the 10g Instant Client. The 3.4 version will not detect an Instant Client. [/QUOTE]

I've tried to work with Instant Client (doa 4.0.6.1) and i have some problems at design-time :

1. I need to set (via the corresponding run parameter) the oci.dll to use; without this running the application within Delphi fails because the program doesn't recognize the oracle client software.

2. the query builder doesn't works

Is this the correct behauvior or I'm doing something wrongs ?

Regards

Sergio Sette

 

[Marco Kalter]

This indicates that you have not set the ORACLE_HOME environment variable in Windows. This is a general Instant Client requirement.

 

[sergio.sette]

Originally posted by Marco Kalter:
This indicates that you have not set the ORACLE_HOME environment variable in Windows. This is a general Instant Client requirement.

The TNS_ADMIN variable is not enugh ? According to Oracle documentation

If TNS_ADMIN is not set, OCI will examine an operating system dependent set of directories to find tnsnames.ora. This search path includes looking in the directory %ORACLE_HOME%/network/admin/tnsnames.ora. This is the only reason to set the ORACLE_HOME environment variable for Oracle Instant Client. If ORACLE_HOME is set when running Instant Client applications, it must be set to a directory where Instant Client exists (in this case C:\Oracle\instantclient).

So i've not set the oracle_home variable because the TNS_ADMIN sholud be the preferred way to configure the instant client.

Best regards

sergio sette

 

[Marco Kalter]

I guess we're not doing it right. We'll add support for TNS_ADMIN instant client detection.

 

[SvenHeuer]

Any news (timeframe) to this topic?

Greetings
Sven

 

[Marco Kalter]

If you need a pre-release for this, just let me know.

 

[AlexA]

I would like a pre-release please. Also, if we are providing the full connect string information, IP, Port, Database, Username & Password, then it should find the 10g files if they are in the PATH and connect from there. In our case, the Oracle files are in the application directory so we have to set an environment variable ORACLE_HOME="" to get it to work. Any other ideas?

 

[Marco Kalter]

Setting the PATH environment variable (and optionally the TNS_ADMIN environment variable) should do the trick with the current 4.0.6 release.