Hello everyone,
I just ran into following issue with a big surprise that it does not work in
ODBC.
What I am doing is:
- set the isolation level to: SQL_TXN_SERIALIZABLE
- then connect to postgres database via ODBC function SQLDriverConnect()
Example code:
ret = SQLSetConnectAttr(hDbc, SQL_ATTR_TXN_ISOLATION,
(SQLPOINTER)SQL_TXN_SERIALIZABLE, SQL_IS_INTEGER);
ret = SQLDriverConnect(hConnect,
0,
(SQLCHAR*)connString,
ustrlen((unsigned char *)connString),
NULL,
0,
NULL,
SQL_DRIVER_NOPROMPT);
Then SQLDriverConnect() returns -1 with error code: "08001 Already
connected."
With other isolation level like SQL_TXN_READ_COMMITTED, it works fine.
Any idea to solve this problem? Or is this a Postgres ODBC bug? I couldn't
find anything here or on Google.
--
View this message in context:
http://postgresql.nabble.com/ODBC-isolationi-level-SQL-TXN-SERIALIZABLE-08001-Already-connected-tp5923778.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.