ODBC + Dynamic cursors

From: "Amanjit Gill" <amanjit(dot)gill(at)gmx(dot)de>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: ODBC + Dynamic cursors
Date: 2003-07-30 20:06:11
Message-ID: 001101c356d6$066f66a0$0400a8c0@charite.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi, I have written a C++ ODBC wrapper that right now runs on
Oracle,Access,SQL Server, Sybase.
I am right now investigating PostgreSQL which we want to use instead of
SQL Server.

PostgreSQL Version: 7.33 (Cygwin/Windows XP) using ipc-daemon
ODBC Version: 7.03.01.10
OS: Windows XP Pro, SP1

Synopsis:
I basically open a connection to a db, create a statement,use a dynamic
cursor
via SQLSetConnectAttr (SQL_ATTR_CURSOR_TYPE, SQL_CURSOR_DYNAMIC),
execute the statement
, bind some fields and want to fetch data using SQLFetchScroll
(m_hstmt, SQL_FETCH_ABSOLUTE,
lPosition).

The SQLFetchScroll statement fails with the following message:
'HY106 - the fetch type for PGAPI_ExtendedFetch isn't allowed for
ForwardOnly cursor.'

Which of course irritates me because I explicitely use
SQL_CURSOR_DYNAMIC.

I attached the standard windows SQL.log with some mixins of the code I
called. It is not the complete
log and it is not the PostgreSQL-Driver specific log, which is far too
verbose for me.
I have enabled the Dynamic cursor checkbox in the driver.

Any suggestions?

Another question: are positionable updates and deletes (which means
SQLSetPos) possible with
PostgreSQL at present (as mentioned in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/ht
m/odch12pr_2.asp) ?

Thanks for your help

Amanjit Gill
Software Developer
Medical and Bioinformatics
UFK (Gynecology and Obstetrics)
University Clinic Charite
Berlin

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.504 / Virus Database: 302 - Release Date: 24.07.2003


Attachment Content-Type Size
SQL_LOG_MIXED.txt text/plain 4.5 KB

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Janet Borschowa 2003-07-30 20:52:40 Re: ODBC + Dynamic cursors
Previous Message Schleis, David 2003-07-29 14:00:52 Re: Problems with ORACLE