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

Re: SQLExecute get result to client?

From: Ludek Finstrle <xfinstrl(at)informatics(dot)muni(dot)cz>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: SQLExecute get result to client?
Date: 2002-01-28 13:50:10
Message-ID: 20020128145010.B14401@anxur.fi.muni.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
> > 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.

I tried this. But it has no effect. I'll try it once more.

Thanks

Luf

In response to

pgsql-odbc by date

Next:From: Joseph WatsonDate: 2002-01-28 22:53:20
Subject: Re: Connection Problem
Previous:From: Hiroshi InoueDate: 2002-01-28 09:55:02
Subject: Re: Connection Problem

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