Connection Pooling

[Breck_Carter]

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?

[Breck_Carter]

Not sure where "connection pooling" comes into play... you can have as many instances of an application connecting that you want, all at the same time, subject to licensing restrictions.

[VolkerBarth]

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).

[Former Member]

I never noticed the Pooling tab in ODBC Admin. Thanks for pointing it out.