資料庫連接字串 – IBM DB2

資料庫連接字串 - IBM DB2

ODBC DSN

// ODBC DSN   using System.Data.Odbc;   OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =               "Dsn=DsnName;" +               "Uid=UserName;" +               "Pwd=Secret;"; conn.Open();

 

ODBC without DSN

// ODBC without DSN   using System.Data.Odbc;   OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =               "Driver={IBM DB2 ODBC DRIVER};" +               "DataBase=DataBaseName;" +               "HostName=ServerName;" +               "Protocol=TCPIP;" +               "Port=PortNumber;" +               "Uid=UserName;" +               "Pwd=Secret;"; conn.Open();

 

OleDb -- Microsoft Driver

// OleDb -- Microsoft Driver   using System.Data.OleDb;   OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =            "Driver=DB2OLEDB;" +            "Network Transport Library=TCPIP;" +            "Network Address=xxx.xxx.xxx.xxx;" +            "Package Collection=CollectionName;" +            "Initial Catalog=DataBaseName;" +            "User id=UserName;" +            "Password=Secret;"; conn.Open();

 

OleDb -- IBM Driver

// OleDb -- IBM Driver   using System.Data.OleDb;   OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =             "Driver=IBMDADB2;" +             "DataBase=DataBaseName;" +             "HostName=ServerName;" +             "Protocol=TCPIP;" +             "Port=PortNumber;" +             "Uid=UserName;" +             "Pwd=Secret;"; conn.Open();

 

.NET DataProvider from IBM

// .NET DataProvider from IBM   using IBM.Data.DB2;   Db2Connection conn = new Db2Connection(); conn.ConnectionString =               "DataBase=DataBaseName;" +               "Uid=UserName;" +               "Pwd=Secret;" + conn.Open();