ODBC README: This document contains a checklist of items you should follow to get ODBC running on your client machine (Windows/Linux/Solaris/HP-UX/AIX). Instruction for UNIX platforms:- IF No ODBC Driver Manager on Client: 1. Install an ODBC Driver Manager on Client · You can find one at www.unixodbc.com, · click 'download' button, · click the 'download' button in the page, · follow the instructions to 'Make the Libraries and Programs', about half way down the page, · note: to run the make install item, you must be logged in as root 2. Follow the 'ODBC Driver Manager exists' instructions. ODBC Driver Manager exists: 1. Install the Netezza Client Software for Linux/Solaris, 2. Set the library environment variable · Add '/usr/local/nz/lib' to the LD_LIBRARY_PATH variable (on Linux/Solaris, SHLIB_PATH on HP-UX, LIBPATH on AIX) (Example 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/nz/lib') 3. Follow the 'If ODBC ini files exist' or 'If ODBC ini files do not exist' instructions. If ODBC ini files exist: 1. Copy the contents of the 'odbcinst.ini.sample' file into your corresponding INI file. 2. For each new data source, copy the contents of the NZSQL data source with the 'odbc.ini.sample' file, and make the necessary changes (server, database, user, password) into your corresponding INI file. Refer "NetezzaSQL ODBC Datasource Configuration Help" below in this document. 3. Export ODBCINI environment variable to odbc.ini file path and NZ_ODBC_INI_PATH environment variable to the directory where INI files reside. If ODBC ini files do not exist: 1. Copy the file 'odbcinst.ini.sample' to your home directory, naming the file '.odbcinst.ini'. 2. Copy the file 'odbc.ini.sample' to your home directory, naming the file '.odbc.ini'. 3. For each data source, copy the contents of the NZSQL data source and make the necessary changes (server, database, user, password). Refer "NetezzaSQL ODBC Datasource Configuration Help" below in this document. 4. Export ODBCINI environment variable to odbc.ini file path and NZ_ODBC_INI_PATH environment variable to the directory where INI files reside. Instructions for Windows platform:- Installing Driver Manager on Windows is not required. Use "ODBC DataSource Administrator" program in "Administrative Tools" to configure Datasource and Driver options (INI settings). For configuration help, refer "NetezzaSQL ODBC Datasource Configuration Help" below in this document. DSN OPTIONS: Data Source: A name used to identify the database connection properties. Description: A decription used to identify the database connection properties. Database: The name of a database. Server: The name of a machine or IP address where the database is located. Port: The port number to connect. User Name: The name of a valid user. Password: The password for the user. ADVANCED DSN OPTIONS: ReadOnly: Only Select SQL statements will be allowed if this field is checked. All other SQL statements will cause an error. Show System Tables: When displaying available tables, should system tables be included in the list. Treat Numeric as Char: When selected, driver treats SQL_C_NUMERIC buffers as SQL_C_CHAR buffers. By default, this is not selected meaning SQL_C_NUMERIC will be treated as Numeric Structures by default. Return SQL_BIT as 1/0: When checked, a binding to char/wchar will return SQL_BIT (boolean columns) as "1"/"0". If unchecked, the driver returns "t"/"f". SSL DSN OPTIONS: SecurityLevel: specifies the security level that you want to use for the session. The argument has four values: preferredUnSecured — This is the default value. Specify this option when you would prefer an unsecured connection, but you will accept a secured connection if the NPS system requires one. preferredSecured — Specify this option when you want a secured connection to the NPS system, but you will accept an unsecured connection if the NPS system is configured to use only unsecured connections. onlyUnSecured — Specify this option when you want an unsecured connection to the NPS system. If the NPS system requires a secured connection, the connection will be rejected. onlySecured — Specify this option when you want a secured connection to the NPS system. If the NPS system accepts only unsecured connections, or if you are attempting to connect to an NPS system that is running a release prior to 4.5, the connection will be rejected. CACertFile: specifies the pathname of the root certification authority (CA) file. The CA file must be obtained from the NPS system administrator and installed on the client system. The CA file authenticates the server (the NPS host) to the client. The default value is NULL, which indicates that no peer authentication will occur. DRIVER OPTIONS: DebugLogging ( "Enable debug Logging" on Windows ): A boolean value to activate debug logs. Possible values are 1, true, 0, false. LogPath ( "Log File Path" on Windows ): Path where the log files should be placed. Default is /tmp on Unix and "C:\" on windows. UnicodeTranslationOption: Specify translation option for Unicode. Possible value strings are: utf8 : unicode data is in utf-8 encoding utf16 : unicode data is in utf-16 encoding utf32 : unicode data is in utf-32 encoding Do not add '-' in the value strings listed above, e.g. "utf-8" is not a valid string value. These value strings are case insensitive. On windows this option is not available as windows DM always passes unicode data in utf16. CharacterTranslationOption ( "Optimize for ASCII character set" on Windows ): Specify translation option for character encodings. Possible value strings are: all : Support all character encodings latin9 : Support Latin9 character encoding only Do not add '-' in the value strings listed above, e.g. "latin-9" is not a valid string value. These value strings are case insensitive. NPS uses the Latin9 character encoding for char and varchar datatypes. The character encoding on many Windows systems is similar, but not identical to this. For the ASCII subset (letters a-z, A-Z, numbers 0-9 and punctuation marks) they are identical. If your character data in CHAR or VARCHAR datatypes is only in this ASCII subset then it will be faster if this box is checked. If your data has special characters such as the Euro sign (€) then keep the box unchecked to accurately convert the encoding. Characters in the NCHAR or NVARCHAR data types will always be converted appropriately. Prefetch Count: A numeric value that sets the number of rows the driver will fetch at a time from a Netezza database. The default is 256 rows. To tune your application, set a value that optimizes network use verses PC memory use. Realize that the higher this value, the more PC memory will be required to hold these rows. Socket Buffer Size: A numeric value which the driver uses to size the socket buffer to tune to network speed.