Re: ODBC Connection Pooling (Windows 2000 MDAC 2.7 patched,

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: cgg007(at)yahoo(dot)com
Cc: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC Connection Pooling (Windows 2000 MDAC 2.7 patched,
Date: 2003-09-04 23:49:43
Message-ID: 3F57CF97.1680E509@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Chris Gamache wrote:
>
> That is my point exactly. That is why (windows?) connection
> pooling breaks this model. It wouldn't be a problem if there
> were a way to undefine currval() for all sequences...
> It would be a command issued by the ODBC driver when the
> connection is made (best), or by the connecting process as
> its first order of business (do-able).

How could the driver know if the connection is recycled ?
SQL..Connect API function isn't called when the connection
is recycled.

regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message E. Zorn (RDG-rational) postsql 2003-09-05 07:17:52 Re: Change connection (IP, or Databasename)
Previous Message Dave Cramer 2003-09-04 22:54:20 cursors in asp