Connection strings for Netezza DBMS
Providers for Netezza DBMS
Community Forums
Find solutions and post questions regarding connection string related issues.
Netezza OLE DB
Type
OLE DB Provider
Usage Provider=NZOLEDB
Manufacturer Netezza
Usage Provider=NZOLEDB
Manufacturer Netezza
Standard
Provider=NZOLEDB;Password=myPassword;User ID=myUsername;Data Source=myServerAddress;Initial Catalog=myDataBase;Persist Security Info=True;Port=PortNumber;Logging Level=0 or 1;Log Path=Path to log;Optimize for ASCII=True / False;
NetezzaSQL ODBC Driver
Type
.NET Framework Class Library
Usage
Manufacturer Netezza
Usage
Manufacturer Netezza
Standard
Driver={NetezzaSQL};servername=myServerAddress;port=myPortNumber;database=myDataBase; username=myUsername;password=myPassword;
.NET Framework Data Provider for ODBC
Type
.NET Framework Wrapper Class Library
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
Bridging to NetezzaSQL ODBC Driver
This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.
Driver={NetezzaSQL};servername=myServerAddress;port=myPortNumber;database=myDataBase; username=myUsername;password=myPassword;
Selected Articles