Two Oracle Connections
Posted: 29.04.2011, 19:39
Hello!
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:
In connection component TZConnection I set the property as follows:
However, I have one more component TZConnection in my application and during implementation want to open a new connection with the scheme FRANK setting the properties as follows:
However, when calling the Connect method, the following error is raised:
Opening a connection only works, but two simultaneous connections in different schemas does not work.
How can I do to have two simultaneous connections in ZEOS?
Greetings,
Josimar
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