SQLSetConnectAttr( hdbc, SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF,0) is no use

--------------050302050609040604010601
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi

I use MyODBC 3.51 under linux.

With SQLSetConnectAttr( hdbc, SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF, 0);
SQLEndTran(SQL_HANDLE_DBC,hdbc,SQL_ROLLBACK); does nothing.

I try many times. Finally I wrote this code:
char autocommit[]="SET AUTOCOMMIT=0";
rc = SQLExecDirect(hstmtset,(SQLCHAR*)autocommit,sizeof(autocommi t)-1);
Then SQLEndTran(SQL_HANDLE_DBC,hdbc,SQL_ROLLBACK) works!

Does MyODBC support SQLSetConnectAttr( hdbc, SQL_ATTR_AUTOCOMMIT,
SQL_AUTOCOMMIT_OFF, 0)?
Or I do something wrong?

Thanks

regards,

Gu Lei

--

--------------050302050609040604010601
Content-Type: multipart/related;
boundary="------------030800040709010805000001"


--------------030800040709010805000001
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit








Hi



I use MyODBC 3.51 under linux.



With  SQLSetConnectAttr( hdbc, SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF,
0);

SQLEndTran(SQL_HANDLE_DBC,hdbc,SQL_ROLLBACK); does nothing.



I try many times. Finally I wrote this code:

        char autocommit[]="SET AUTOCOMMIT=0";

        rc =
SQLExecDirect(hstmtset,(SQLCHAR*)autocommit,sizeof(autocommi t)-1);

Then SQLEndTran(SQL_HANDLE_DBC,hdbc,SQL_ROLLBACK) works!



Does MyODBC support SQLSetConnectAttr( hdbc, SQL_ATTR_AUTOCOMMIT,
SQL_AUTOCOMMIT_OFF, 0)?

Or I do something wrong?



Thanks



regards,



Gu Lei

--