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(" Connection String: {0}", conn.ConnectionString); Console.WriteLine(" Database: {0}",conn.Database); Console.WriteLine(" ServerVersion: {0}",conn.ServerVersion); Console.WriteLine(" State: {0}",conn.State); } catch (DB2Exception e) { Console.WriteLine("Error: " + e); } finally { conn.Close(); Console.WriteLine("Connection closed."); } } }