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

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 (view raw or flat)
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

pgsql-patches by date

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

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