Instant Client with TNS_ADMIN

[kochin]

Hi,

I understand that Instant Client does not need tnsnames.ora to connect to the server. I can connect with SQL*Plus on Instant Clinet.
> sqlplus user/pass@IPAddr/ServiceName

But I specified IPAddr/ServiceName to LogonDatabase of TOracleSession and it does not work fine.
Is tnsnames.ora mandatory on DOA?

 

[Marco Kalter]

No, you can also use EZCONNECT like in your example. What is your exact Direct Oracle Access version, and what exactly goes wrong?

 

[kochin]

Marco,

Version 4.0.7.1
Is EZCONNECT a demo program? Where is it?

Thank you,

 

[Marco Kalter]

No, it is the name for the host/service naming resolution.

Can you let me know what exactly goes wrong?

 

[kochin]

I inputed "//HostName:1521/orcl.mydomain.com" for the LogonDatabase property of TOracleSession component. I tried to connect this session but following message appears.
"ORA-06401" NETCMN: invalid driver designed"

 

[Marco Kalter]

Is EZCONNECT listed in the directory path in your sqlnet.ora file? For example:

NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)

 

[kochin]

No.
Why do I need sqlnet.ora file on Instant Client? I could connect to the Oracle server using SQL*Plus without sqlnet.ora file.

Because I don't want to set TNS_ADMIN parameter on a lot of client PC, I am testing Instant Clinet.

Cannot I use TOracleSession without sqlnet.ora file?

Thank you,

 

[Marco Kalter]

If you want to specify which name resolution you want to use, you need an sqlnet.ora. This has nothing to do with Direct Oracle Access, but is simply an Oracle Client requirement.