MFC连接Sqlserver-osbreak

下载 ado2.h和ado2.cpp文件

在VC++ 目录-->包含目录 -->添加 msado15.dll, msjro.dll 目录。

// TODO: 连接sqlserver， 在stdafx.h 中定义这些，#define _BS_DLL_EXPORT_# ifdef _BS_DLL_EXPORT_
# define BS_DLL_EXPORT __declspec(dllexport)
# else# define BS_DLL_EXPORT __declspec(dllimport)
# endif

连接sqlserver数据库bool connectToSqlServer()
{
 CADODatabase *g_pAdoDatabase; try{ if (g_pAdoDatabase == NULL)
 g_pAdoDatabase = new CADODatabase();

 CString strConnString = "Provider=SQLOLEDB;Persist Security Info=False;Data Source=" + \
 strServer + ";Initial Catalog=" + strDatabase + ";User Id=" + strUser + ";Password=" + strPwd;

 g_pAdoDatabase->SetConnectionString((LPCTSTR)strConnString);
 } catch (...)
 { return false;
 } return true;
}

if(g_pAdoDatabase->Open())
{ // 查询
 CString sqlText = "select ...";
 
 CADORecordset* pRs = new CADORecordset(g_pAdoDatabase); if(pRs->Open((LPCTSTR)sqlText))
 { while (!pRs->IsEof())
 {
 pRs->GetFieldValue("id", ID);
 pRs->MoveNext();
 }
 }
 pRs->Close();
 delete pRs; 
}catch (...)
{
 return false;
}if(g_pAdoDatabase->IsOpen())
{
 g_pAdoDatabase->Close();
}