#include <string>
//c:\Program Files\Common Files\System\ADO\msado15.dll
#import "msado15.dll" no_namespace rename("EOF", "EndOfFile")
using namespace std;
int _tmain(int argc, _TCHAR* argv[])
{
::CoInitialize(NULL);
_ConnectionPtr m_pConnection=NULL;
_RecordsetPtr m_pRecordset=NULL;
m_pConnection.CreateInstance(__uuidof(Connection));
m_pRecordset.CreateInstance(__uuidof(Recordset));
_bstr_t strConnect = "Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;\
User ID=sa;Initial Catalog=testdb;Data Source=192.168.1.3";
_bstr_t bstrSQL("select * from testTable");
try
{
m_pConnection->Open(strConnect, "","", adModeUnknown);
m_pRecordset->Open(bstrSQL, m_pConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);
_variant_t vstr, vuint;
while (!m_pRecordset->EndOfFile)
{
vstr = m_pRecordset->GetCollect("str");
vuint = m_pRecordset->GetCollect("uint");
string str = (_bstr_t)vstr.bstrVal;
unsigned int uint = vuint.ulVal;
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
}
catch (_com_error e)
{
return 0;
}
if(m_pConnection->State)
{
m_pConnection->Close();
}
::CoUninitialize();
return 0;
}
C++使用ADO连接SQLSERVER
最新推荐文章于 2024-05-26 21:18:18 发布