Configuring Additional Connector Options in Windows

You can configure connector options to modify the behavior of the connector.

To configure additional connector options in Windows:

1. To access the additional connector options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then select the Misc tab.
2. To ignore spaces between function names and parentheses ( ( ) in statements so that function names are treated as keywords, select the Ignore Space After Function Names check box.
3. To disable support for transactions, select the Disable Transaction Support check box.
4. To translate the minimum ODBC date value to the MariaDB zero date value when binding parameters, select the Bind Minimal Date As Zero Date check box.
   Note:

   Enabling this option prevents statements from failing because of what seems to be a mismatch in the date values.

5. To emulate prepared statements on the client side, select the Prepare Statements On The Client check box.
6. To treat a quotation mark (") as an identifier quote character instead of a string quote character, select the Enable ANSI Quotes check box.
7. To save your settings and close the Simba MariaDB ODBC Driver DSN Setup dialog box, click OK.