| From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
|---|---|
| To: | "Venkatesan, Sekhar" <sekhar(dot)venkatesan(at)emc(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>, "Rao, Raghavendra" <raghavendra(dot)rao(at)emc(dot)com>, "Choudhuri, Saurav" <saurav(dot)choudhuri(at)emc(dot)com> |
| Subject: | Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! |
| Date: | 2016-01-30 04:45:18 |
| Message-ID: | 56AC3FDE.1040400@dream.email.ne.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Viktor Trojanovic | 2016-02-01 20:29:04 | Issues with PostgreSQL ODBC on Win 10 |
| Previous Message | Adrian Klaver | 2016-01-29 21:29:51 | Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!! |