DOA Client on PC with 64 bit server

[G Spears]

Hello,
I am running version 4.1.1, on Windows 10 64 bit. I have Oracle 12.1.0.2, 64 installed on this server. I need to run Oracle 64 bit on the same server as DOA 32 bit. I have downloaded the Instant Client 32 bit. I am having challenges getting both to work together. Without Instant Client, SQL*PLus and SQL Developer work fine, both with and without a TNS Connection (aka username/password@PROD (which is both my service and SID name). I run the DeptEmp client, and connect connect, can't find oci.dll. I set $PATH (top entry) to include the instant-client, and then TNS does want to work properly. Is there a trick to getting DOA to use 32 bit, but leaving the server stuff using 64 bit?

 

[Marco Kalter]

To use the Instant Client you need to set the following environment variables:

• PATH
  Needs to include the Instant Client directory (where oci.dll is located).
• ORACLE_HOME
  Set it to the Instant Client directory.
• TNS_ADMIN
  Needs to point to the directory where tnsnames.ora is located.
• NLS_LANG=language_territory.characterset
  Defines the language, territory, and character set for the client.

You can set these environment variables in a script that launches your application, so that it does not affect the server itself.

 

[G Spears]

That will work fine ONCE that application is written and released production, but what about in a development environment? These changes would need to be applied to Delphi, and then when I run the app from within Delphi, wouldn't the app then use the O/S environment settings?

G Spears

 

[Marco Kalter]

I think the application will inherit the environment variables. If not, you can set the environment variables during the initialization of your application before it makes a connection to the database.