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

SQLExecute get result to client?

From: Ludek Finstrle <xfinstrl(at)informatics(dot)muni(dot)cz>
To: pgsql-odbc(at)postgresql(dot)org
Subject: SQLExecute get result to client?
Date: 2002-01-27 21:47:06
Message-ID: 20020127224706.B9888@anxur.fi.muni.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello,

  I have one question. It's not fatal error but very annoying thing.

My configuration:
-----------------
 server - Linux RH 7.2 + postgresql 7.1.3
 client - WinNT 4.0 Workstation + postgresql ODBC 7.01.00009

Problem description:
--------------------
I have application (without source) that test table with:

SQLPrepare "select * from table" with return code 0
SQLNumResultCols  with return code 0
SQLDescribeCol  with return code 0    (for each column)
SQLExecute  with return code 0
SQLFreeStmt  with return code 0

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?

Thanks

Luf

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-01-27 23:46:19
Subject: Re: SQLExecute get result to client?
Previous:From: Joseph WatsonDate: 2002-01-27 04:46:25
Subject: Re: Connection Problem

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