Csharp/C Sharp/Database ADO.net/DB2
OleDbConnection Connect to DB2: DB2 connection string
<source lang="csharp"> 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."); } }
}
</source>
Use DB2Connection class to connect to a DB2 database
<source lang="csharp"> 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."); } }
}
</source>