Netezza DBMS connection strings

Netezza OLE DB

  • 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;
Problems connecting?
Get answer in the Netezza DBMS Q & A forum

.NET Framework Data Provider for OLE DB

  • Use an OLE DB provider from .NET

    Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

    See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.

NetezzaSQL ODBC Driver

  • Standard

    Driver={NetezzaSQL};servername=myServerAddress;port=myPortNumber;
    database
    =myDataBase;username=myUsername;password=myPassword;

.NET Framework Data Provider for ODBC

  • Use an ODBC driver from .NET

    Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;

    See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.

Q&Aask question »

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.