vsado连接mysql_vs2010 c++使用ADO方法连接数据库

#include#import "I:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF", "adoEOF")

void main()

{

_ConnectionPtr m_pConnection; //到access数据库的链接对象

_RecordsetPtr m_pRecordset; //结果集对象

CoInitialize(NULL); //初始化

try

{

m_pConnection.CreateInstance("ADODB.Connection");///创建Connection对象

m_pConnection->Open("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=../data/rule.accdb;Persist Security Info=False","","",adModeUnknown);///连接数据库

}

catch(_com_error e)///捕捉异常

{

MessageBox(NULL, e.Description(), "连接错误", MB_OK);

}

m_pRecordset.CreateInstance("ADODB.Recordset"); //创建Recordset对象

_variant_t RecordsAffected;

m_pRecordset = m_pConnection->Execute("select * from rule where pre='hsh'",&RecordsAffected,adCmdText);

_variant_t result = m_pRecordset->GetCollect("con");

MessageBox(NULL, (char*)(_bstr_t)result, "查询结果", MB_OK);

m_pRecordset->Close();///关闭记录集

m_pConnection->Close();///关闭连接

}