Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!
От | Adrian Klaver |
---|---|
Тема | Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! |
Дата | |
Msg-id | 56BA0257.2030909@aklaver.com обсуждение исходный текст |
Ответ на | Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! ("Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>) |
Ответы |
Re: PostgreSQL: Autocommit through windows odbc driver
doesnt work!!!
|
Список | pgsql-odbc |
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.klaver@aklaver.com] > Sent: Saturday, January 30, 2016 3:00 AM > To: Venkatesan, Sekhar; Joshua D. Drake; pgsql-odbc@postgresql.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@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 > -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-odbc по дате отправления: