C# 存取 DB2 資料庫（二）：Server Explorer 拖曳建立連線、OLE DB 連線字串完整參數避免手寫錯誤

Server Explorer 建立連線

1. VS 新建 ASP.NET 專案
2. 啟動 Server Explorer，拖曳現有 DB2 連線至 Web Form
3. OLE DB 連線字串參數自動寫入程式碼

自動產生的連線字串

this.oleDbConnection1.ConnectionString = @"Provider=DB2OLEDB;
Cache Authentication=False;
Integrated Security="";
PassWord=freebsd9;
Persist Security Info=True;
User ID=userid;Initial Catalog=qcdb;
Data Source=qcdb;Mode=ReadWrite;
Extended Properties="";
APPC Remote LU Alias="";
APPC Local LU Alias="";
APPC Mode Name=QPCSUPP;
Network Transport Library=TCPIP;
Host CCSID=37;PC Code Page=1282;
Network Address=172.23.169.1;
Network Port=4444;Package Collection=qcdb;
Default Schema=userid;Alternate TP Name="";
Process Binary as Character=False;
Units of Work=RUW";

透過設計工具產生連線字串可避免手寫參數錯誤，快速實現資料庫連線。