I have an Oracle server with various schemes. Two of them are called:
JOE
FRANK
On the client computer I installed the Oracle Instant Client and TNSNAMES.ORA configured as follows:
Code: Select all
MYORA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev.orcl.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
Code: Select all
object dbJOE: TZConnection
Database = MYORA
HostName = dev.orcl.com
Password = mypassword
Port = 1521
Protocol = oracle
User = JOE
end
Code: Select all
object dbFRANK: TZConnection
Database = MYORA
HostName = dev.orcl.com
Password = mypassword
Port = 1521
Protocol = oracle
User = FRANK
end
Code: Select all
OCI_ERROR: ORA-12154
How can I do to have two simultaneous connections in ZEOS?
Greetings,
Josimar