Обсуждение: autocommit question

Поиск
Список
Период
Сортировка

autocommit question

От
Дата:

Hi,
I've tried to set autocommit to off with the following command in a c++ application

 SQLSetConnectAttr(hdbc, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER)SQL_AUTOCOMMIT_OFF, SQL_NTS);

but that doesn't have the expected result.

Autocommit is still in state "ON" -> every command is handled as a single transaction ?

When using a explicit "BEGIN" -> real transaction handling is possible (as expected)

Why does SQLSetConnectAttr not cause the expected behavior ?

Best regards

tom