Connection Pooling and currval - Mailing list pgsql-odbc

From Chris Gamache
Subject Connection Pooling and currval
Date
Msg-id 20030225201215.50956.qmail@web13805.mail.yahoo.com
Whole thread Raw
Responses Connection Pooling and currval
List pgsql-odbc
I've just enabled Connection Pooling on the PostgreSQL+ (Beta) 7.02.00.05, and
I think I'm having some state problems.

I think currval() is returning a value from a recycled connection where it
should be undefined.

I can not duplicate this problem because I can not get the timing right, but it
is indicitive of ODBC pulling an active connection from the connection pool,
and PostgreSQL thinking it is the same connection as before... I'm using a
DSN-less connection... Can I modify this string to ensure that stateful
variables are reset even though the connection has not been (really) severed?

Here's my connection string

"Provider=MSDASQL.1;Password=xxxxxxx;Persist Security Info=True;User
ID=xxxxxxx;Mode=ReadWrite;Extended Properties=""DRIVER={PostgreSQL+

(Beta)};DATABASE=xxxxxxx;SERVER=10.10.0.1;PORT=5432;UID=xxxxxxx;PWD=xxxxxxx;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS="""

Any other suggestions?

CG


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Newer ODBC drivers : exellent !
Next
From: "Ben Trewern"
Date:
Subject: Re: Driver PostgreSql x dbExpress