(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