Question: SQL_Autocommit_off is not implemented

[lxs...@gmail.com]

I tried to use the pyODBC library to connect to a ODBC data source, but always got this error:

pyodbc.Error: ('HYC00', "[HYC00] The 'SQL_AUTOCOMMIT_OFF' for the 'SQL_ATTR_AUTO COMMIT' is not implemented. (0) (SQLSetConnnectAttr(SQL_ATTR_AUTOCOMMIT))")

when use pyodbc.connect("DNS=...")

I also tried the pypyodbc library and got the same error. Any ideas? Thank you very much!

[Michael Kleehammer]

That is an error from your driver, not from pyodbc.  Apparently your driver (and most likely database) does not support autocommit being turned off.  What database are you using?

You'll need to add "autocommit=True" to the connection:

    cnxn = pyodbc.connect(connectionstr, autocommit=True)