On Sat, 2014-06-07 at 06:13 +0900, Inoue, Hiroshi wrote:
>
> (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
Added "UpdatableCursors=1" to the connection string. No difference.
Yes, OpenSUSE has 8.3.0200. Why? I don't know. I downloaded, compiled
and installed version 9.2.0100. Still get the error.