Standard using NZOLEDB

Connection string

This Netezza OLE DB connection string can be used for connections to Netezza DBMS.

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;