Connect using Oracle instant client

[Martin Ben]

Hi,
I'm looking for connect to database using Oracle instant client
Can I use DOA components?

Thanks, Martin

 

[Marco Kalter]

Yes, that is possible. 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).
• 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.

 

[Martin Ben]

Thanks. Can I use tnsnames.ora in directory where my application is? Instead of environment variable TNS_NAMES.

 

[Marco Kalter]

That will work if, during application start-up, you set the TNS_ADMIN environment variable to the application directory.

 

[Martin Ben]

I used your recommendation, but I cannot log on Oracle. I got this exception message:

Initialization error
Oracle Client not properly installed

OracleHomeKey:
OracleHomeDir:

 

[Marco Kalter]

Can you let me know your exact Direct Oracle Access version?

 

[Martin Ben]

4.1.2.0

 

[Marco Kalter]

It should work fine. Can you add the instant client directory as the first entry in the PATH? For example:

PATH=C:\Oracle\InstantClien11g;C:\Windows;C:\Windows\System;...

 

[Martin Ben]

There was a bug in tnsnames.ora

Now it works perfectly. Thanks a lot for your help.