ODBC连接数据库

#include <afxdb.h>       

要包含上面的头文件

CDatabase m_dbConn;

CString szTemp;
szTemp.Format("Driver={SQL Server};Server=%s;UID=%s;PWD=%s;Database=DataCollection;wsid=DataCollection",
"127.0.0.1",
"sa",
"1234567");
BOOL flg = m_dbConn.OpenEx(szTemp, CDatabase::noOdbcDialog);
if (flg)
{
AfxMessageBox("成功");
CRecordset *m_pProof=new CRecordset(&m_dbConn);
CString strSQL = L"select * from t_User";
   m_pProof->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL,CRecordset::none);
// short num = m_pProof->GetRecordCount();
DWORD nRows = 0;
while(!m_pProof->IsBOF())
{
}
nRows = m_pProof->GetRecordCount();