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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2006-12-19 04:42:08 | [ psqlodbc-Bugs-1000836 ] invalid byte sequence for encoding & amp; quot; UTF8& amp; quot; : 0x92 |
Previous Message | Howard B. Golden | 2006-12-19 00:30:25 | Solution for pgsql odbc driver missing from Windows data sources drivers list |