Re: SQLExecute get result to client? - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: SQLExecute get result to client?
Date
Msg-id 3C54914A.B8DEEBB@tpf.co.jp
Whole thread Raw
In response to SQLExecute get result to client?  (Ludek Finstrle <xfinstrl@informatics.muni.cz>)
Responses Re: SQLExecute get result to client?  (Ludek Finstrle <xfinstrl@informatics.muni.cz>)
List pgsql-odbc
Ludek Finstrle wrote:
>

[snip]

> There is difference between Postgres and MSSQL ODBC. Postgres load whole
> result to client in SQLExecute but MSSQL not. Table have +-500000 rows and
> transfer through net takes very long time.
>
> So my question is: Exists some patch to fix this? Or could you help me
> with basic information what I have to change?

Turn on the Use Declare/Fetch option.
It would work well with read-only applications.

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: Ludek Finstrle
Date:
Subject: SQLExecute get result to client?
Next
From: Hiroshi Inoue
Date:
Subject: Re: Connection Problem