Re: ODBC Connection Pooling (Windows 2000 MDAC 2.7 patched, - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: ODBC Connection Pooling (Windows 2000 MDAC 2.7 patched,
Date
Msg-id 3F57CF97.1680E509@tpf.co.jp
Whole thread Raw
In response to Re: ODBC Connection Pooling (Windows 2000 MDAC 2.7 patched, pgodbc-7.02.00.05)  (Chris Gamache <cgg007@yahoo.com>)
Responses Re: ODBC Connection Pooling (Windows 2000 MDAC 2.7 patched, pgodbc-7.02.00.05)  (Chris Gamache <cgg007@yahoo.com>)
List 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/

pgsql-odbc by date:

Previous
From: Dave Cramer
Date:
Subject: cursors in asp
Next
From: "E. Zorn (RDG-rational) postsql"
Date:
Subject: Re: Change connection (IP, or Databasename)