Re: Access, pass-through queries and isolation level

From: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
To: "'Philippe Lang'" <philippe(dot)lang(at)attiksystem(dot)ch>
Cc: "'Jeff Eckermann'" <jeff_eckermann(at)yahoo(dot)com>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Access, pass-through queries and isolation level
Date: 2003-11-07 21:57:19
Message-ID: 007c01c3a57a$1df90cc0$3d283ddb@PbgX
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Przemysław 2003-11-07 22:47:01 ODBC and Sybase PowerDesigner
Previous Message Steve Wampler 2003-11-07 20:30:31 Re: Help with hang on empty query (PG 7.3.2,