IFILE - tnsnames.Ora

[Daril]

Hello,
does Unidac support IFILE parameter in tnsnames.ORA? I found that ODAC support it, but I'm not sure if Unidac too.

IFILE info:
http://docs.oracle.com/cd/B19306_01/ser ... ams081.htm

Thank you

[Daril]

I see it is work fine, only problem is when to IFILE parameter include network path "\\..."

[AlexP]

Hello,

UniDAC, as well as ODAC, supports the IFILE parameter in tnsnames.ora (both local and network paths). Please describe the problem you have encountered when specifying the network path.

[Daril]

Hello Alex,
I tested this situation. I have one tnsNames.Ora on default location (network\admin). In this file I have

OstOracle10g_12 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.40.22)(PORT = 1521))
)(CONNECT_DATA =(SERVICE_NAME = qa))
)

IFILE = \\ostnas\Shared\Daril\Network.Ora

In file Network.Ora I have:

OstOracle10g_Network =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.40.22)(PORT = 1521))
)(CONNECT_DATA =(SERVICE_NAME = qa))
)

I created simple project in Delphi 7 and Unidac 5.1.4. Only TUniConnection I Added and button to test connection.
When I set to TUniConnection.Server to OstOracle10g_12 everythink is OK and I'm able connect to database. When I set TUniConnection.Server to OstOracle10g_Network I obtain

ORA-12154: TNS:could not resolve the connect identifier specified.

When I try IFILE parametr with other not network path everythink run ok.

Thank you

[Daril]

I find solution
Oracle supports only this path
//ostnas\...
not
\\ostnas\...

view
https://community.oracle.com/message/9692439#9692439

[AlexP]

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.