Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!

On 2016/01/29 19:25, Venkatesan, Sekhar wrote:
> Including few people in this loop.
>
> -----Original Message-----
> From: Venkatesan, Sekhar
> Sent: Friday, January 29, 2016 10:04 AM
> To: 'Joshua D. Drake'; 'pgsql-odbc@postgresql.org'
> Subject: RE: [ODBC] PostgreSQL: Autocommit through windows odbc driver doesnt work!!!
>
> HI Joshua,
>
> I perform the following set of operations to set autocommit in postgreSQL through ODBC in windows.
> SQLSetConnectAttr(hDbc, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER) SQL_AUTOCOMMIT_ON,  0)
>
> ret = SQLDriverConnect(_hdbc, NULL, (SQLCHAR*) dsn.GetChars(), SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT);
>
> This doesn't enable autocommit. If I call SQLSetConnectAttr after SQLDriverConnect, autocommit is set.
> Any issue with this sequence? I assume It should be possible to set SQL_ATTR_AUTOCOMMIT before establishing
connection.
> Can you please confirm on this behavior?
>

Unfortunately I can't reproduce it.
Could you take the Mylog output of the case?

regards,
Hiroshi Inoue