From: "Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>, "pgsql-sql@postgresql.org"
 <pgsql-sql@postgresql.org>
Subject: Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!
Thread-Topic: [SQL] PostgreSQL: Autocommit through windows odbc driver
 doesnt work!!!
Thread-Index: AdFZlKwYGssRJphmQLWh8p8v4os3FAAffUOAAApPZrA=
Date: Thu, 28 Jan 2016 16:33:28 +0000
Message-ID: <F84DE43FDACD4C45AA84E2DA016FAE2F1C65A804@MX105CL01.corp.emc.com>
References: <F84DE43FDACD4C45AA84E2DA016FAE2F1C65A5FC@MX105CL01.corp.emc.com>
 <56AA4157.4040509@aklaver.com>
In-Reply-To: <56AA4157.4040509@aklaver.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Hi Adrian,

Thanks for getting back to me.=20
I am new to this forum. Can you please explain how to post my message in od=
bc list?
How to contact this list there? Is there any email ID alias?
Please help.

Thanks,
Sekhar

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]=20
Sent: Thursday, January 28, 2016 9:57 PM
To: Venkatesan, Sekhar; pgsql-sql@postgresql.org
Subject: Re: [SQL] PostgreSQL: Autocommit through windows odbc driver doesn=
t work!!!

On 01/27/2016 10:31 PM, Venkatesan, Sekhar wrote:
> Hi All,
>
> I am trying  to certify our product with PostgreSQL database and=20
> facing an issue with windows odbc driver and need your help to=20
> identify the problem.
>
> Our application uses SQLDriverConnect to connect to PostgreSQL server.=20
> I am using PostgreSQL odbc driver version 9.4
>
> SQLSetConnectAttr to enable autocommit as below:
>
> Eg: SQLSetConnectAttr(SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_ON, 0)
>
> But it seems autocommit is not set and hence any queries executed from=20
> other session never gets updated data in other session since=20
> autocommit of insert statements never happens.
>
> Only workaround I am seeing is to explicitly issue "commit" to save=20
> the updates in the database.
>
> Has anyone seen this issue earlier? I see a relevant issue in psqlODBC
> 09.05.0100 Release something like below:
>
> https://odbc.postgresql.org/docs/release.html
>
> 1.*Don't reset autocommit when a connection is established*
>
> If autocommit is disabled on a connection, by calling=20
> SQLSetConnectAttr(SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF, 0), before=20
> connecting with SQLDriverConnect(), autocommit was incorrectly reset=20
> back to on when the connection was established.
>
> Is the above issue fixed? Also in my use-case, I want to enable=20
> 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 an=
y.

The only answer I have is that you might get an answer sooner if you post t=
his to the -odbc list:

http://www.postgresql.org/list/pgsql-odbc/

>
> Thanks,
>
> Sekhar
>


--
Adrian Klaver
adrian.klaver@aklaver.com


--=20
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql