| 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
| 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] |