Configuring Connection Options

You can configure options to modify how the connector handles connections and specify connector behavior that applies at connection time.

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

To configure connection options:

1. To access the connection options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then select the Connection tab.
2. To compress the communication between the client and the server, select the Use Compression check box.

Note:

Compression may reduce the amount of network traffic for certain workflows, but in some cases it may increase CPU usage.

3. To automatically reconnect to the server when a communication link error occurs, select the Enable Automatic Reconnect check box.
4. To prevent the connector from opening dialog boxes to prompt for additional information during connection time, select the Don't Prompt When Connecting check box.
5. To enable support for batched statements, select the Allow Multiple Statements check box.
6. To allow sandboxed connections through which you can reset the password after attempting to connect using an expired password, select the Can Handle Expired Password check box.
7. To close the connection after it has been inactive for the amount of time specified by the interactive_timeout setting on the server, select the Interactive Client check box.
8. In the Initial Statement field, type a statement for the connector to execute immediately after connecting to the server.
9. To save your settings and close the Simba MySQL ODBC Driver DSN Setup dialog box, click OK.

Related topics

• Creating a Data Source Name
• Creating a Data Source Name
• Driver Configuration Options
• Connection Configuration Options