Validating the .NET Provider installation

Before you try to access a .NET data source, ensure that the Netezza .NET Provider installation was successful.


  1. Create an application that is based on .NET Framework. A C# example follows:
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Threading.Tasks;
    using System.Data.Common;
    using System.Data;
    namespace Sample_Connection
    class Program
    static void Main(string[] args)
    DbProviderFactory factory = DbProviderFactories.GetFactory("NZdotNET");
    DbConnection con = factory.CreateConnection();
    con.ConnectionString = "Server =;Port = 5480;
    Database = system;User id = admin;PWD = password;level=3;logname=c:\\";
    Console.WriteLine("Connected successfully.......");
    DbCommand cmd = con.CreateCommand();
  2. Compile the application.
  3. Run the application.
    If the application runs successfully, the Netezza Performance Server .NET Provider was successfully installed.