Configuring Cursor and Result Options in Windows

You can configure how the connector handles cursors and query results.

To configure cursor and result options in Windows:

  1. To access the cursor and result options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then select the Cursor/Results tab.
  2. To reduce memory consumption by preventing the connector from caching result sets into memory, select the Don't Cache Results Of Forward-Only Cursors check box.
  3. To specify what the connector returns after DML operations, do one of the following:
    • To return the number of matched rows, select the Return Matched Rows Instead Of Affected Rows check box.
    • Or, to return the number of affected rows, clear the Return Matched Rows Instead Of Affected Rows check box.
  4. To respect the sql_auto_is_null setting specified in the server instead of automatically disabling it, select the Enable SQL_AUTO_IS_NULL check box.
    Note:

    For more information about sql_auto_is_null, see "Server System Variables" in the MariaDB documentation: https://mariadb.com/kb/en/mariadb/server-system-variables/#sql_auto_is_null.

  5. To specify how the connector handles date values where the month or day is 0, do one of the following:
    • To translate zero dates to a date value that is supported by ODBC, select the Return Minimal Date For Zero Date check box.
    • To return zero dates as NULL, clear the Return Minimal Date For Zero Date check box.
  6. To save your settings and close the Simba MariaDB ODBC Driver DSN Setup dialog box, click OK.