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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Enabling connection pooling by default


  • From: "Andrus" <kobruleht2(at)hot(dot)ee>
  • To: <pgsql-odbc(at)postgresql(dot)org>
  • Cc: "Andrei Kovalevski" <andyk(at)commandprompt(dot)com>
  • Subject: Re: Enabling connection pooling by default
  • Date: Wed, 15 Oct 2008 18:21:42 +0300
  • Message-id: <A8D0269B3A984E679C31D6C970857474@andrusnotebook> <text/plain>

Thank you.

So the program flow should be

1. Read registry key HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL Unicode\CPTimeout 2. It it does not exists or is zero, application requires registry write access and wrote this key with value 60

Is this best solution ?
Or is there some ODBC api function which can used for this ?

I'm bit confused by the fact that pooling is not turned on by default.
So almost every PostgreSQL ODBC application does not use pooling.

Is connection pooling tested and works OK with unicode driver ?
Can pooling turned on by default in next driver release ?

Andrus.

----- Original Message -----
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




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group