Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group