Hi Roland,

I can't add any insight for connection pooling with SQL Anywhere from PowerBuilder but is this the doc you were looking for: https://help.sap.com/doc/68c565f3ab4f480ea42a59fa2ebd444e/17.0.01/en-US/SQL-Anywhere-Server-Database-Administration-en.pdf

HTH...regards,

Mark

Hi Roland;

  For both PowerBuilder and PowerServer, Connection pooling to any "pooling aware DB driver" is controlled outside of PB / PS via the ODBC layer within the DSN itself via the ODBC Administrator utility. For example:

HTH

Regards .., Chris

I got the following from the PDF that Mark linked to. It appears that the default is YES so I only need to use it when I want a different Timeout or MaxCached.

ConnectionPool

Controls the behavior of client connection pooling.

{ ConnectionPool | CPOOL }={ NO | YES [ ( [ Timeout=timeout-sec; ] [ MaxCached=max-cachedconn ] ) ] }

timeout-sec = Idle timeout in seconds before the connection is dropped.
max-cachedconn= The maximum number of cached connections from each application.

Default:

ConnectionPool YES
Timeout=60
MaxCached=5

Example:

;ConnectionPool=YES (Timeout=60; MaxCached=5);