From: | Andrei Kovalevski <andyk(at)commandprompt(dot)com> |
---|---|
To: | Postgresql ODBC List <pgsql-odbc(at)postgresql(dot)org> |
Cc: | Andrus <kobruleht2(at)hot(dot)ee> |
Subject: | Re: Enabling connection pooling by default |
Date: | 2008-10-15 14:56:55 |
Message-ID: | 48F604B7.4090708@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2008-10-15 15:21:42 | Re: Enabling connection pooling by default |
Previous Message | Andrus | 2008-10-15 14:43:02 | Re: Enabling connection pooling by default |