Setting Connector-Wide Configuration Options

When you specify connection settings in a DSN or connection string, those settings apply only when you connect to Netezza using that particular DSN or string. As an alternative, you can specify settings that apply to every connection that uses the Simba Netezza ODBC Driver by configuring them in the simba.netezzaodbc.ini file.

Note:

Settings in the connection string take precedence over settings in the DSN, and settings in the DSN take precedence over connector-wide settings.

To set connector-wide configuration options:

  1. Navigate to the lib subfolder in the connector installation directory, and then open the simba.netezzaodbc.ini configuration file in a text editor.
  2. In the [Driver] section, specify configuration options as key-value pairs. Start a new line for each key-value pair.

    3. For example, to authenticate the connection using "simba" as the user name and "simba123" as the password, type the following:

    UID=simba

    PWD=simba123

    For detailed information about all the configuration options supported by the connector, see Driver Configuration Options on page 1.

  3. Save the simba.netezzaodbc.ini configuration file.

Related topics

  • Driver Configuration Options on page 1
  • Configuring the Driver on page 1