Multiple aliases in tnsnames.ora

ChrisSlater · Post by **ChrisSlater** » Mon 23 Jan 2006 01:23

It is possible for a user to configure a tnsnames entry to have multiple aliases. EG :

alias1, alias2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracledb.x.y.z)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracledb)
)
)

Currently ODAC does not handle this well. To fix this ODAC needs to make the following change :

In OdacGui.inc, line 227 (version 5.55);
Replace this line:

if (St = '=') and (Bracket = 0) then begin

With this:

if ((St = '=') or (St = ',')) and (Bracket = 0) then begin

Challenger · Post by **Challenger** » Mon 23 Jan 2006 15:10

We will consider you suggestion. And perhaps include fix in the next build of ODAC.