在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();
}