Configuring Advanced Options

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

The following instructions describe how to configure advanced options in a DSN. You can specify the connection settings described below in a DSN, in a connection string, or as connector-wide settings. Settings in the connection string take precedence over settings in the DSN, and settings in the DSN take precedence over connector-wide settings.

For detailed information about the options on this page, see Advanced Driver Configuration Options on page 1 or Client Driver Configuration Options.

To configure advanced options:

  1. To access the advanced options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then select the Advanced DSN Options tab.
  2. To use the connector in read-only mode, select the Read Only check box.
  3. To display the system tables used by the data store, select the Show System Tables check box.
  4. To return SQL_BIT values as 1 or 0, select the Return SQL_BIT as 1/0 check box.

    5. Or, to return SQL_BIT values as t or f, clear the Return SQL_BIT as 1/0 check box.

  5. If you are using Kerberos authentication, then to use GSSAPI for authentication, select the Use GSSAPI check box.
  6. Specify the date format by selecting one of the Date Format options:
    • MDY: The connector returns dates in MDY format, for example, 08-15-2019.
    • DMY: The connector returns dates in DMY format, for example, 15-08-2019.
    • YMD: The connector returns dates in YMD format, for example, 2019-08-15.
  7. In the Client User Id, Client Workstation Name, Client Application Name, Client Account String, and Client Program Info fields, specify the client properties to send to the server when the session begins.
  8. In the Login Timeout field, type the length of time, in seconds, before the login times out. To cause the login to never time out, type 0.
  9. In the Query Timeout field, type the length of time, in seconds, before the query times out. To cause the query to never time out, type 0.
  10. In the Load Max Errors field, type the maximum number of errors to accept during inserts with parameter arrays. Once the connector has received this many errors, the query fails.
  11. To save your settings and close the Simba Netezza ODBC Driver DSN Setup dialog box, click OK.

Related topics