Devart Forums

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

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

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.

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

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

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

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