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

On 01/28/2016 08:36 PM, Venkatesan, Sekhar wrote:
> 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?

I would say it is this bug:

http://www.postgresql.org/message-id/55BD0ABE.5010800@iki.fi

So have you tried the latest psqlodbc version, 09.05.0100 ?

>
> Thanks,
> Sekhar
>
> -----Original Message-----
> From: Joshua D. Drake [mailto:jd@commandprompt.com]
> Sent: Thursday, January 28, 2016 11:14 PM
> To: Venkatesan, Sekhar; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] PostgreSQL: Autocommit through windows odbc driver doesnt work!!!
>
> On 01/28/2016 08:53 AM, Venkatesan, Sekhar wrote:
>
>> Is the above issue fixed? Also in my use-case, I want to enable
>> autocommit at odbc driver level but even that doesn't work.
>>
>> The same application works in Linux OS when unix odbc driver is used.
>> This seems to be specific to windows driver.
>>
>> Please shed some light on this. Do ask me further question if you have any.
>>
>
> By default PostgreSQL "autocommits". If it isn't in your case, your driver is starting a transaction and not
committingit. 
>
> Sincerely,
>
> JD
>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com