I am using SQL Anywhere 11 and have my database running as a service on Windows XP.
The docs only mention connection pooling for the .Net Provider. I am connecting from PowerBuilder using ODBC.
I will have multiple instances of the app connecting at the time using the same exact connection parameters.
Can this be done?
asked 16 Feb '11, 17:22
The complete connection string has to be identical. It includes the APPINFO part in which the process id and thread id is mentioned. So in reality connection pooling is only possible if the connection attempt comes from the same thread in the same process.
EDIT: According to this answer by Ian, the above statement is not completely true:
I'm not sure but I guess connection pooling as a general product feature has been introduced with SA 12.
Cf. the new CPOOL connection parameter.
I don't know whether the general ODBC connection pooling (cf. the ODBC Admin's according tab) works with SQL Anywhere (and if so, how well it works).
answered 17 Feb '11, 09:01