Installation guide

mxODBC - Python ODBC Database Interface
5.10 mxODBC Subpackages ..................................................... 85
5.10.1 One API for all Subpackages ................................................................ 86
6. mxODBC Connection Objects........................... 87
6.1 Subpackage Support ......................................................... 87
6.2 Connection Type Object ................................................... 87
6.3 Connection Object Constructors ...................................... 87
Connect(dsn, user='', password='', clear_auto_commit=1,
errorhandler=None, connection_options=())............................ 87
connect(dsn, user='', password='', clear_auto_commit=1,
errorhandler=None).................................................................. 88
DriverConnect(DSN_string, clear_auto_commit=1,
errorhandler=None).................................................................. 88
ODBC(dsn, user='', password='', clear_auto_commit=1,
errorhandler=None).................................................................. 89
6.4 Default Transaction Settings.............................................. 89
6.4.1 Overriding the Default......................................................................... 89
6.4.2 Errors due to missing Transaction Support........................................... 90
6.5 Connection objects as context managers .......................... 90
6.5.1 Introduction to Context Managers .......................................................90
6.5.2 Using connection objects as context object ......................................... 90
6.6 Unicode/ANSI Connections............................................... 91
6.6.1 Unicode ODBC Interface ..................................................................... 91
6.6.2 ANSI ODBC Interface ..........................................................................91
6.7 Connection Object Methods............................................. 92
.close() ......................................................................................92
.commit() .................................................................................. 92
.cursor(name=None, cursor_options=())..................................92
.getconnectoption(option) ......................................................... 92
.getinfo(info_id)......................................................................... 92
.nativesql(command)................................................................. 93
.rollback().................................................................................. 93