20751-12 Rev.5 5-9
Installing and Configuring ODBC for Windows
system administrator for the database to which you are attempting to connect.
Refer to the Netezza Administrator’s Guide for information on security and
authentication.
The Driver Options tab allows you to configure global driver options, as shown in
Figure 5-7.
Figure 5-7: Driver Options.
Enable Debug Logging — Select this box if you want the system to log information
about each ODBC connection. This information may be helpful in debugging con-
nection problems. For more information, see Appendix B, “Troubleshooting.”
Log File Path — The location of the debug log files. The default is c:\ on Windows
systems.
Optimize for ASCII character set — The Netezza appliance uses the Latin9 charac-
ter encoding for char and varchar types. The character encoding for many Windows
systems is similar, but not identical. If your database includes characters that use
only the basic subset of letters (a-z or A-Z), numbers (0-9), or punctuation charac-
ters, select the Optimize for ASCII character set option for the driver on Windows,
which will improve query performance. If your data includes special characters
such as the Euro symbol or others, de-select the option to ensure that the charac-
ters convert correctly.
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 versus memory use. Realize
that the higher this value, the more memory will be required to hold these rows.
Socket Buffer Size — A numeric value that specifies the size of the communica-
tions buffer in bytes. The range is 1K to 32K. The default is 8192.
Test the Connection When finished selecting DSN and Driver options, select the DSN
Options tab and and click the Test Connection button to establish a connection to this data
source on your Netezza appliance server. A message box displays, indicating that the con-
nection attempt was either successful or failed. If the connection attempt fails, check for
erroneous configuration information, correct it, and test the connection again. If you cannot
establish a connection after checking for errors, contact your Netezza system administrator.
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels