ConnectionPool with PowerBuilder

[former_SQLA_member1694946]

I'm looking for tips on using ConnectionPool with SA17 and PowerBuilder.

My app is connecting/disconnecting frequently using the same userid/password. I can't use a long term connection due to how it is structured.

[former_SQLA_member1694946]

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

[VolkerBarth]

Hm, have you answered your own question, or is this just an addition to your question?