Configuring Additional Connector Options

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

For detailed information about the options on this page, see Additional Driver Configuration Options.

To configure additional connector options:

  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 MySQL zero date value when binding parameters, select the Bind Minimal Date As Zero Date check box.

    5. 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 MySQL ODBC Driver DSN Setup dialog box, click OK.

Related topics