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 Windows Registry.

Note:

  • Settings in the connection string take precedence over settings in the DSN, and settings in the DSN take precedence over connector-wide settings.
  • If the LogLevel configuration property is passed in via the connection string or DSN, the rest of the logging configurations are read from the connection string or DSN and not from the existing connector-wide logging configuration.

To set connector-wide configuration options:

  1. Choose one:
    • If you are using Windows 7 or earlier, click Start Windows Start button, then type regedit in the Search field, and then click regedit.exe in the search results.
    • Or, if you are using Windows 8 or later, on the Start screen, type regedit, and then click the regedit search result.
  2. Navigate to the appropriate registry key for the bitness of your connector and your machine:
    • If you are using the 32-bit connector on a 64-bit machine, then browse to the following registry key:

      • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Simba\Simba Netezza ODBC Driver\Driver

    • Otherwise, browse to the following registry key:

      • HKEY_LOCAL_MACHINE\SOFTWARE\Simba\Simba Netezza ODBC Driver\Driver

  3. For each connection property that you want to configure, do the following:
    1. Right-click the Driver subkey and then select New > String Value.
    2. Type the key name of the connection property, and then press Enter.

      3. For example, to specify the user name for authentication, type UID. To verify the supported key name for each connector configuration option, refer to the "Key Name" column in the description of the option in Driver Configuration Options on page 1.

    3. Right-click the value that you created in the previous steps and then click Modify.
    4. In the Edit String dialog box, in the Value Data field, type the value that you want to set the connection property to and then click OK.

      5. For example, to specify "simba" as the user name for authentication, type simba.

  4. Close the Registry Editor.

Related topics

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