| From: | "John C(dot) Frickson" <john(at)frickson(dot)us> |
|---|---|
| To: | "Inoue, Hiroshi" <inoue(at)tpf(dot)co(dot)jp> |
| Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL ODBC List <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: SQLBulkOperations |
| Date: | 2014-06-06 23:28:57 |
| Message-ID: | 1402097337.8234.43.camel@server.frickson.pvt |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Inoue, Hiroshi | 2014-06-07 02:20:00 | Re: Need new psqlODBC release to update OpenSSL again |
| Previous Message | Inoue, Hiroshi | 2014-06-06 21:13:08 | Re: SQLBulkOperations |