Skip to Content
May 22, 2016 at 08:07 AM

Connection pooling issues


Hello, all

I have a completely unclear picture regarding connection polling in our .NET service, which connects to SQL anywhere 16 through OdbcConnection class (c#).

First of all, the service is getting a lot of Failed to connect to DB errors and I believe that one of the issues here is that it is not using a connection pool of the ODBC driver.

Main question: how to recognize a polled connection from Sybase central connection tab (or from a sa_conn_info() view, I am not picky on the tool)?

My second question: Can ODBC driver pool connections which connect to the same DB, but do not have identical connection strings. This particular service assigns CON and THREAD values to the connection string before calling CreateConnection() function, so almost all connection string are different.

My third question: Is connection id of the db connection changes after being reused by connection poll cache? So, if the client queries the polled connection info, will it see the same connection id on multiple occurrences?

Thank you

Arcady Abramov