Re: Access, pass-through queries and isolation level - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Access, pass-through queries and isolation level
Date
Msg-id 007c01c3a57a$1df90cc0$3d283ddb@PbgX
Whole thread Raw
In response to Re: Access, pass-through queries and isolation level  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
List pgsql-odbc
> -----Original Message-----
> From: Philippe Lang
>
> Here we are...
>
> I understand more or less that the second query is not
> recognized as a select statement... That's apparently the
> reason why I cannot get the value back in Access.
>
> Are "multiple result sets" supposed to work with the ODBC driver?

Yes.
Psqlodbc driver returns 2 results for the query(SET ..;SELECT ..).
An SQLMoreResults call is needed to see the second result.

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: Steve Wampler
Date:
Subject: Re: Help with hang on empty query (PG 7.3.2,
Next
From: Jeff Eckermann
Date:
Subject: Re: Help with hang on empty query (PG 7.3.2,