Re: SQLBulkOperations

(2014/06/06 21:55), John C. Frickson wrote:
> /etc/unixODBC/odbcinst.ini:
>    [PSQL]
>    Description     = PostgreSQL
>    Driver64        = /usr/lib64/psqlodbcw.so
>    UsageCount      = 1
>
> I set attributes like this:
>
> SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0);
> SQLSetConnectAttr(hdbc,SQL_ATTR_ODBC_CURSORS,(SQLPOINTER)SQL_CUR_USE_ODBC,0);
> SQLSetStmtAttr(hstmt,SQL_ATTR_CONCURRENCY, SQL_CONCUR_ROWVER, 0);
> SQLSetStmtAttr(hstmt,SQL_ATTR_CURSOR_TYPE,SQL_CURSOR_KEYSET_DRIVEN,0);
>
> Connection is DSN-less using connection string:
> DRIVER={PGSQL};SERVER=xx.xxx.xx.x;UID=user;PWD=pass;DATABASE=MyDB;UseServerSidePrepare=1;

Please try to add UpdatabelCursors=1 to your connection string.
BTW is the version of the driver 8.3.0200 not 9.3.0200?

regards,
Hiroshi Inoue