Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere ODBC API » Choosing an ODBC connection function » Establishing a connection

 

Setting connection attributes

You use the SQLSetConnectAttr function to control details of the connection. For example, the following statement turns off ODBC autocommit behavior.

retcode = SQLSetConnectAttr( dbc, SQL_AUTOCOMMIT,
   (SQLPOINTER)SQL_AUTOCOMMIT_OFF, 0 );

For more information including a list of connection attributes, see [external link] SQLSetConnectAttr in the Microsoft ODBC Programmer's Reference.

Many aspects of the connection can be controlled through the connection parameters. For information, see Connection parameters.