在VC中用ADO訪問SQLserver數據庫的簡單問題

#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF")

然後:

HRESULT hr;

try

{

hr = m_pConnection.CreateInstance("ADODB.Connection");///創建Connection對象

if(SUCCEEDED(hr))

{

m_pConnection->ConnectionTimeout=2;///設置超時時間為2秒

//以下是連接access2000數據庫。。。

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

//連接SQL數據庫

// m_pConnection->CursorLocation = adUseClient;

// m_pConnection->IsolationLevel = adXactReadCommitted;

// m_pConnection->Open("Provider=SQLOLEDB;Server=127.0.0.1;DATABASE=kgd;UID=sa;PWD=","","",adModeUnknown);

}

}

catch(_com_error e)///捕捉異常

{

CString temp;

temp.Format("連接數據庫錯誤信息:%s",e.ErrorMessage());

::MessageBox(NULL,temp,"提示信息",NULL);

AfxMessageBox(e.Source());

AfxMessageBox(e.Description());

return false;

}

我是這樣幹的.很健康