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)
        {
            var = m_pRecordset->GetCollect("ID");
            if(var.vt != VT_NULL)
                ID= _com_util::ConvertBSTRToString((_bstr_t)var);
           
    var = m_pRecordset->GetCollect("name");
            if(var.vt != VT_NULL)
                name=_com_util::ConvertBSTRToString((_bstr_t)var);
   
            cout<<ID<<" is "<<name<<endl;
            m_pRecordset->MoveNext();
        }
    }
    catch(_com_error *e)
    {
        cout<<e->ErrorMessage()<<endl;
}
     m_pRecordset->Close();
   m_pRecordset = NULL;  
    if(m_pConnection->State)
   m_pConnection->Close();
    m_pConnection= NULL;
return 0;
}