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

On 02/08/2016 08:10 PM, Venkatesan, Sekhar wrote:

Ccing list.

> Hi Adrian,
>
> Sorry for getting back to you late. I tried with psqlodbc version, 09.05.0100 but the issue is still seen?
> Let me know what next step I can follow to root cause this? Any tracing you would suggest?

I do not have an answer, returning this to list for those that might.

>
> Thanks,
> Sekhar
>
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
> Sent: Saturday, January 30, 2016 3:00 AM
> To: Venkatesan, Sekhar; Joshua D. Drake; pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] 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(at)commandprompt(dot)com]
>> Sent: Thursday, January 28, 2016 11:14 PM
>> To: Venkatesan, Sekhar; pgsql-odbc(at)postgresql(dot)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 committing it.
>>
>> Sincerely,
>>
>> JD
>>
>>
>>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com