Hello Santhoshkumar,
I got an answer from one of our teammates:
"The connections from ACE to a database via ODBC are not pooled. Each ACE thread makes and manages its own connection to each database that it uses.Looking at the error messaeg in the link I do not think pooling would help here. How ever the link does not give enough context to understand what is happening. The context shows ACE tried to connect to the Oracle DB but that Oracle (probably the Oracle listener) rejected the connection attempt."
Let me know if this is helpful for you and if you have any other questions.
Best
------------------------------
Gabriel Marte Blanco
Austin TX
------------------------------
Original Message:
Sent: Thu November 17, 2022 05:14 PM
From: santhoshkumar surisetty
Subject: connection pool in odbc oracle driver
Hi ,
do we have connection pool configuration in odbc.ini configuration file . if we have,could you please suggest that how can we enable it as we are facing connection issues .i am not able to figure out . IIB version is iib-10.0.0.25
Exception connection to database: afdds, ODBC, adadfd, Root SQL exception: -1, daadfd, Child SQL exception: 08001, -1, [unixODBC][IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination,
------------------------------
santhoshkumar surisetty
------------------------------