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

Re: Query batches and SQLMoreResults

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Michael Kochetkov <mkochetkov(at)hotmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Query batches and SQLMoreResults
Date: 2006-12-19 03:35:15
Message-ID: 45875DF3.6040001@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Michael Kochetkov wrote:
> Hello,
> let us consider the following test case. There are two tables T1 that 
> has int and varchar fields and T2 that has varchar, datatime and blob 
> fields. Then we have a query batch like this:
> select * from T1;
> select * from T2
> 
> It executes with ODBC and gets the first recordset as expected. But then 
> I have problems. SQLMoreResults says there is another recordset. 
> SQLNumResultCols says there are 3 columns indeed. But subsequent 
> SQLDescribeCol calls return wrond descriptions. The first call for it 
> says, for example, that the first field of the second recordset is of 
> type SQL_INTEGER while I expect it to be varchar. And subsequent 
> SQLFetch fails.
> 
> I use the latest PostgreSQL 8.2 binaries for Win32.
> 
> So, does current PostgreSQL ODBC driver supports query batches and 
> SQLMoreResults?

Please try the snapshot dll at
  http://www.geocities.jp/inocchichichi/psqlodbc/index.html
.
At least SQLDescribeCol would return correct result.
SQLNumParams doesn't work properly though.

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: noreplyDate: 2006-12-19 04:42:08
Subject: [ psqlodbc-Bugs-1000836 ] invalid byte sequence for encoding &amp;amp;quot;UTF8&amp;amp;quot;: 0x92
Previous:From: Howard B. GoldenDate: 2006-12-19 00:30:25
Subject: Solution for pgsql odbc driver missing from Windows data sources drivers list

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