C++通过ADO连接ACCESS(或者SQL Server)数据库例子

#include "iostream.h"
#include "stdio.h"
#import "C:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF")
int main(int argc, char* argv[])
{
   ::CoInitialize(NULL);
_ConnectionPtr m_pConnection;
m_pConnection.CreateInstance("ADODB.Connection");
try               
    {
   m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database\\mydb.mdb","","",adModeUnknown);
//m_pConnection->Open("Server=192.168.0.150,1433;uid=sa;pwd=123456;DATABASE=temp;Provider=SQLOLEDB;","","",-1);//连接SQL Server
}
catch(_com_error e)
{
        cout<<"数据库连接失败，确认数据库mydb.mdb是否在当前路径下!"<<endl;
   return FALSE;
    }
_RecordsetPtr m_pRecordset;
m_pRecordset.CreateInstance("ADODB.Recordset");
try
    {  
        m_pRecordset->Open("SELECT * from test",
   m_pConnection.GetInterfacePtr(),
   adOpenDynamic,
   adLockOptimistic,
   adCmdText);
}
catch(_com_error *e)
    {
        cout<<e->ErrorMessage()<<endl;
    }  
    _variant_t var;
    char *ID,*name;
    try
    {
        if(!m_pRecordset->BOF)
            m_pRecordset->MoveFirst();
        else {
            cout<<"表内数据为空"<<endl;
    return 1;
    }
   while(!m_pRecordset->adoEOF)
        {