Re: Enabling connection pooling by default

Hello,

I have discovered this problem a little. It seems to me installer has to
set "CPTimeout" registry key to some integer value. This will enable
pooling by default. Here is this registry key:

HKEY_LOCAL_MACHINE\Software\Odbc\Odbcinst.ini\ODBC_driver_name\CPTimeout

Andrus wrote:
> Richard,
>
> thank you.
>
> Maybe connection pooling is ODBC driver manager function, not ODBC
> driver itself.
> In this case ODBC driver manager should have some special setting in
> connection string like Driver=
> which applies for all drivers.
>
> Why connection pooling is not turned ON by msi installer ?
> Maybe there is some command line option or is it possible to write to
> registry to turn in on.
> I do'nt like the idea to force end users to set this.
> How to check whether conn pooling is active and issue warning to user
> if not ?
>
> Andrus.
>
>
> ----- Original Message ----- >
> This is the official list of options that can be passed to the driver.
>> Unfortunately I didn't see any options for connection pooling:
>>
>> http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/psqlodbc/psqlodbc/docs/config-opt.html?rev=1.1&content-type=text/plain
>>
>
>

--
Andrei Kovalevski
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/