ADO访问数据库.

.h文件中

 _ConnectionPtr pConnection;                                                                         
 _variant_t RecordsAffected;

atdafx.h文件中

#include <afxdb.h>
#import "C:/Program Files/Common Files/system/ado/msado15.dll" no_namespace rename ("EOF","adoEOF")

dll文件:msado15.dll

.lib文件:odbc32.lib

(OnInitDialog)初始化库

::CoInitialize(NULL);

BOOL CCISSQLDBDlg::ConnectDB(CString serverip, CString database, CString username, CString userpass)//
{
 HRESULT hr;
 try
 {
  hr = pConnection.CreateInstance("ADODB.Connection");
  if (SUCCEEDED(hr))
  {
   CString sql;
   sql.Format("driver={SQL Server};Server=%s; DATABASE=%s; UID=%s; PWD=%s",serverip,database,username,userpass);
   hr = pConnection->Open((LPCTSTR)sql, "", "", adModeUnknown);//执行连接数据源
  }
 }
 catch (_com_error e)
 {
  AfxMessageBox(e.Description());
  return false;
 }
 return true;
}