Re: ODBC isolationi level SQL_TXN_SERIALIZABLE -> "08001 Already connected."

Hello,

Looking at the code, That seems to be a psqlODBC's bug. psqlODBC tries to execute "SET SESSION ... ISOLATION LEVEL ..." upon the call to SQLSetSetConnectAttr(), which fails because the connection is not established yet. The driver should run the SET query after establishing the connection. FYI, even though SQLSetConnectAttr() for other isolation levels returns SQL_SUCCESS, it doesn't set the isolation level correctly.

The workaround is to call SQLSetConnectAttr() after SQLDriverConnect(). Anyway, I'll consider fixing the bug.

Regards
Takayuki Tsunakawa

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Hong06
> Sent: Friday, September 30, 2016 10:41 PM
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] ODBC isolationi level SQL_TXN_SERIALIZABLE -> "08001
> Already connected."
>
> 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.