pyODBC error - SQL_Autocommit_off is not implemented

Question

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!

Which RDMS are you trying to connect to? Please post full connection string. — Parfait, Jul 04 '16 at 02:38

score 3 · Answer 1 · answered Dec 27 '16 at 08:41

3

You should specify autocommit option:

pyodbc.connect("DNS=...", autocommit=True)

answered Dec 27 '16 at 08:41

Bruno Gabuzomeu

1,061
8
9

Worked for me when connecting to MongoDB using it's ODBC driver. – Glushiator Nov 24 '22 at 16:28

pyODBC error - SQL_Autocommit_off is not implemented

1 Answers1

Linked