Hello!
We use ODAC 5.5 and Oracle Server 9.2 (Windows 2000, Linux)
It's well known, that string like "192.168.0.1:1521:SDPV1" should be used in Connect String.
The problem is that we must connect to Oracle Server through Oracle Connection Manager using Net Option, but we don't know how to do it.
A Connection Description in TNSNAMES.ORA looks like:
SDPV1.TRANS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1630))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.169.0.1)(PORT = 1521))
(SOURCE_ROUTE = YES)
)
(CONNECT_DATA =
(SERVICE_NAME = SDPV1.TRANS)
)
)
Could you tell me what should be written in Connect String in this case.
Best regards,
Boris