Configuring Driver Options

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

The following instructions describe how to configure driver 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

To configure driver options:

  1. To access the driver options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then select the Driver Options tab.
  2. To specify the size of the communications buffer between the data store and the connector, in bytes, in the Socket Buffer Size field, type a number of bytes between 4096 and 131072.
  3. To specify the number of rows to cache in memory at once, in the Prefetch Count field, type the number of rows.
  4. To reset these values to their original defaults, click Reset Defaults.
  5. To save your settings and close the Simba Netezza ODBC Driver DSN Setup dialog box, click OK.

Related topics