56,677
社区成员
发帖
与我相关
我的任务
分享
strcpy(strCmd, "SELECT * INTO example IN ODBC [ODBC;Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=test;USER=root;Pwd=12345;]FROM tb_testcase");
int _tmain(int argc, _TCHAR* argv[])
{
CoInitialize(NULL);
::ADOX::_CatalogPtr pCatalog;
::_ConnectionPtr pCon;
::_RecordsetPtr pRs;
char strConn[MAX_PATH];
memset(strConn, 0, sizeof(strConn));
strcpy(strConn, "Provider=Microsoft.Jet.OLEDB.4.0; Data source=D:\\temp\\TestSuiteNameSample_001E4FB28661_20120216191327.mdb");
pCon.CreateInstance(__uuidof(Connection));
pRs.CreateInstance(__uuidof(Recordset));
try
{
pCon->Open(_bstr_t(strConn), "", "", NULL);
}
catch(_com_error &e)
{
cout<<e.Description()<<endl;
}
char strCmd[MAX_PATH];
memset(strCmd, 0, sizeof(strCmd));
strcpy(strCmd, "SELECT * INTO IN ODBC [ODBC;Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=test;USER=root;Pwd=12345;]FROM tb_testcase");
_variant_t RecordAffected;
try
{
pCon->Execute((_bstr_t)strCmd,&RecordAffected, adCmdText);
}
catch(_com_error &e)
{
cout<<e.Description()<<endl;
}
pCon->Close();
CoUninitialize();
return 0;
}