Re: SQLBulkOperations

From: "Inoue, Hiroshi" <inoue(at)tpf(dot)co(dot)jp>
To: "John C(dot) Frickson" <john(at)frickson(dot)us>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: PostgreSQL ODBC List <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: SQLBulkOperations
Date: 2014-06-06 12:13:42
Message-ID: 5391B076.8070208@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

How are you setting UpdatableCursors option?
You have to set the option=1 when you use SQLBulkOperations().

regards,
Hiroshi Inoue

(2014/06/06 20:57), John C. Frickson wrote:
> On Fri, 2014-06-06 at 13:37 +0900, Michael Paquier wrote:
>> On Fri, Jun 6, 2014 at 12:32 PM, John C. Frickson <john(at)frickson(dot)us> wrote:
>>> Is there a problem with the SQLBulkOperations function? When I call
>>> SQLBulkOperations(hstmt, SQL_ADD) I get an error: "[IM001] Driver does
>>> not support this function".
>>>
>>> I'm probably missing something simple. Help please?
>> What is the version of Postgres ODBC and ODBC lib used? the OS? I am
>> seeing in the code that SQLBulkOperations is used if odbc version
>> protocol is newer than 0x0300.
>
> Versions:
>
> OpenSUSE 13.1 x86_64
> PostgreSQL 9.2.7
> psqlODBC 08.03.0200
> unixODBC 2.3.1

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message John C. Frickson 2014-06-06 12:55:06 Re: SQLBulkOperations
Previous Message John C. Frickson 2014-06-06 11:57:19 Re: SQLBulkOperations