Skip site navigation (1) Skip section navigation (2)

Re: Enabling connection pooling by default

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 (view raw or flat)
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/


In response to

Responses

pgsql-odbc by date

Next:From: AndrusDate: 2008-10-15 15:21:42
Subject: Re: Enabling connection pooling by default
Previous:From: AndrusDate: 2008-10-15 14:43:02
Subject: Re: Enabling connection pooling by default

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group