The connection transaction mode cannot be set by the ODBC driver. The connection will use the default driver defined transaction mode.