(1)通過(guò)JET數(shù)據(jù)庫(kù)引擎對(duì)ACCESS2000數(shù)據(jù)庫(kù)的連接

m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\test.mdb","","",adModeUnknown);

(2)通過(guò)DSN數(shù)據(jù)源對(duì)任何支持ODBC的數(shù)據(jù)庫(kù)進(jìn)行連接:


m_pConnection->Open("Data Source=adotest;UID=sa;PWD=;","","",adModeUnknown);

(3)不通過(guò)DSN對(duì)SQL SERVER數(shù)據(jù)庫(kù)進(jìn)行連接：

m_pConnection->Open("driver={SQL Server};Server=127.0.0.1;DATABASE=vckbase;UID=sa;PWD=139","","",adModeUnknown);

其中Server是SQL服務(wù)器的名稱，DATABASE是庫(kù)的名稱

Connection對(duì)象除Open方法外還有許多方法，我們先介紹Connection對(duì)象中兩個(gè)有用的屬性ConnectionTimeOut與State
ConnectionTimeOut用來(lái)設(shè)置連接的超時(shí)時(shí)間，需要在Open之前調(diào)用，例如:

m_pConnection->ConnectionTimeout = 5;///設(shè)置超時(shí)時(shí)間為5秒
m_pConnection->Open("Data Source=adotest;","","",adModeUnknown);


State屬性指明當(dāng)前Connection對(duì)象的狀態(tài)，0表示關(guān)閉，1表示已經(jīng)打開(kāi)，我們可以通過(guò)讀取這個(gè)屬性來(lái)作相應(yīng)的處理，例如:


if(m_pConnection->State)
m_pConnection->Close(); ///如果已經(jīng)打開(kāi)了連接則關(guān)閉它