Installing the ODBC driver for Windows by using the GUI

You can install an ODBC driver by using a GUI. The examples are for a Windows 7 system, but the procedure is similar for other Windows systems.

1. Start the GUI installation program in one of two ways:
   • Double-click the nzodbcsetup.exe executable file. It is in the /drivers directory of the Windows installation package.
   • On the command line, enter nzodbcsetup.exe. The following example uses the C: drive; however, you can install wherever appropriate:

     C:\>nzodbcsetup.exe

2. In the language option window, accept the default of English.
   The language option window controls the language for the installation program.
3. In the Introduction window, review the information and click Next.
4. If you are given the option to select the bit size of the driver to install, select 32-bit, 64-bit, or both.
   The bit size option window is displayed only on 64-bit systems.
5. In the Character Translation Option window, specify whether you will use only the basic subset of characters, such as letters (a - z or A - Z), numbers (0 - 9), or punctuation marks, for the char and varchar data types.
   If you will use only these characters, select the Optimize for ASCII character set check box to help improve data transfer performance. However, if you will use characters such as the Euro symbol or other characters that are outside the basic set, do not select the Optimize for ASCII character set check box. Selecting this check box causes the characters that you enter to be converted to the correct encodings so that they are displayed correctly in your query results.
   Click Next.
6. On the client system, install the Visual Studio C++ 2010 (VS2010) libraries.
7. In the Pre-Installation Summary window, review your installation choices. To make different choices, you can click Previous.
8. Click Install.
   The installation program does the following processing:

   • Installs the Netezza Performance Server ODBC driver. A 32-bit driver on a 32-bit system and a 64-bit driver on a 64-bit system are installed in the \WINDOWS\system32 folder. If you are installing both 32-bit and 64-bit drivers on a 64-bit system, the 32-bit driver is installed in the \WINDOWS\SysWOW64 folder.
   • Places entries in the Windows registry to add your selected ODBC driver to the driver list.
   • Places entries in the Windows registry to add the NZSQL data source to the data source list.
9. In the Installation Complete window, click Done.