Problem in doing bulk inserts thru ODBC API calls

From: "Harish Agarwal" <harish(at)convexant(dot)com>
To: <pgsql-patches(at)postgresql(dot)org>
Subject: Problem in doing bulk inserts thru ODBC API calls
Date: 2001-03-21 05:14:49
Message-ID: 200103210014.AA6095184@convexant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hello,
I am facing a problem with the SQLBulkOperations call with argument SQL_ADD. Though the SQL_ODBC_VER and DRIVER_ODBC_VER, (reflected by SQLGetInfo) is 3.51 and 06.40.0007 respectively.

The return code for the call
SQLBulkOperations(h_stmt, SQL_ADD) is -1 and the error returned is [unixODBC]Only SQL_POSITION/REFRESH is supported for SQLSetPos, SQLSTATE=HYC00.

How do I verify that the driver supports (or not) a call to SQLBulkOperations with SQL_ADD.

Is there some other way of getting bulk inserts done. The ODBC driver being used is one provided by PostODBC for PostGres.

regards & thanks,
Harish

Browse pgsql-patches by date

  From Date Subject
Next Message Dave Page 2001-03-21 11:27:21 RE: MULTIBYTE support
Previous Message Bruce Momjian 2001-03-21 04:34:48 Re: patch for BETWEEN [ASYMMETRIC|SYMMETRIC]