Csharp/C Sharp/Database ADO.net/DB2

OleDbConnection Connect to DB2: DB2 connection string

using System;
using System.Data;
using System.Data.OleDb;
class Db2Connect{
   static void Main() {
      string connString = @"provider = IBMDADB2.1;persist security info = false;data source = sample;";
      OleDbConnection conn = new OleDbConnection(connString);
      try
      {
         conn.Open();
         Console.WriteLine("Connection opened.");
         Console.WriteLine("Connection Properties:");   
         Console.WriteLine("\tConnection String: {0}", conn.ConnectionString);    
         Console.WriteLine("\tDatabase: {0}",conn.Database);   
         Console.WriteLine("\tDataSource: {0}",conn.DataSource);
         Console.WriteLine("\tServerVersion: {0}",conn.ServerVersion);
         Console.WriteLine("\tState: {0}",conn.State);
      } catch (OleDbException e) {
         Console.WriteLine("Error: " + e);  
      } finally {
         conn.Close();
         Console.WriteLine("Connection closed.");
      }
   }
}

Use DB2Connection class to connect to a DB2 database

using System;
using System.Data;
using IBM.Data.DB2;
class Db2Connect{
   static void Main() {
       string connString = @"database = sample;";
       DB2Connection conn = new DB2Connection(connString);
       try {
         conn.Open();
         Console.WriteLine("Connection opened.");
         // Display connection properties
         Console.WriteLine("Connection Properties:");   
         Console.WriteLine("\tConnection String: {0}", conn.ConnectionString);    
         Console.WriteLine("\tDatabase: {0}",conn.Database);   
         Console.WriteLine("\tServerVersion: {0}",conn.ServerVersion);
         Console.WriteLine("\tState: {0}",conn.State);
      } catch (DB2Exception e) {
         Console.WriteLine("Error: " + e);  
      } finally  {
         conn.Close();
         Console.WriteLine("Connection closed.");
      }
   }
}