Example: lrd_db_option

In the following example, the lrd_db_option function sets two ODBC options. The first option activates the ODBC's SQL_TXN_READ_COMMITTED option and the second option deactivates the SQL_AUTOCOMMIT option.

lrd_init(&InitInfo, DBTypeVersion);
lrd_open_context(&Ctx1, LRD_DBTYPE_ODBC, 0, 0, 0);
lrd_alloc_connection(&Con1, LRD_DBTYPE_ODBC, Ctx1, 0 /*Unused*/, 0); 
lrd_db_option
    (Con1, OT_ODBC_TXN_READ_COMMITED,
    LRD_OPTION_VAL_LETTER_YES, 
    LRD_DB_ERROR_SEVERITY_ERROR);
lrd_db_option
    (Con1, OT_ODBC_AUTOCOMMIT, 
    LRD_OPTION_VAL_LETTER_NO, 
    LRD_DB_ERROR_SEVERITY_ERROR);
lrd_open_connection(&Con1, LRD_TYPE_ODBC, "", "", "flight32_quadbase", "", Ctx1, 0, 0);
lrd_open_cursor(&Csr1, Con1, 0);