openingadorecordsetwithimport.cpp

vc ADO 连接数据库

#import  <msado15.dll> rename("EOF", "adoEOF")

struct InitOle {
InitOle()  { ::CoInitialize(NULL); }
~InitOle() { ::CoUninitialize();   }
} _init_InitOle_;

void main( void )
{
    HRESULT                hr = S_OK;
    ADODB::_RecordsetPtr   Rs1 = NULL;
    _bstr_t Connect( "DSN=AdoDemo;UID=admin;PWD=;" );
    _bstr_t Source ( "SELECT * FROM Authors" );

    hr = Rs1.CreateInstance( __uuidof( ADODB::Recordset ) );
    Rs1->Open( Source, Connect, 
               ADODB::adOpenForwardOnly, 
               ADODB::adLockReadOnly, -1 );
    Rs1->Close();
    Rs1 = NULL;
    ::MessageBox( NULL, "Success!", "", MB_OK );
}