adoutils.h

vc ADO 连接数据库

// ADOUTILS:  Header File for helper functions for manipulating ADO within 
//            Visual C++ via #import

#ifndef _ADOUTILS_H_
#define _ADOUTILS_H_

    // Include ADO Interface/Class Descriptions (ADO 1.5 Version)
    #import "C:\Program Files\Common Files\System\ado\msado15.dll" rename( "EOF", "adoEOF" )

    // Need two distinct "empty" VARIANTs and BSTR for various Methods
    extern _variant_t vtEmpty;
    extern _variant_t vtEmpty2;
    extern _bstr_t    bstrEmpty;

    // Connection and SQL Strings
    extern _bstr_t    bstrAccessConnect;
    extern _bstr_t    bstrOpenAccess;
    extern _bstr_t    bstrOpenAccessWithParam;
    extern _bstr_t    bstrSQLCreate;
    extern _bstr_t    bstrSQLDrop;
    extern _bstr_t    bstrStoredProc;

    // (shared) utility functions
    extern void     DumpProperty         ( CHorzListBox &List1, ADODB::_ConnectionPtr Conn1, ADODB::PropertiesPtr &Props1 );
    extern CString  GetPropertyAttributes( ADODB::PropertyAttributesEnum e );
    extern CString  GetType              ( int e );
    extern CString  CrackStrVariant      ( const _variant_t&  var );

    // Event Handlers
    extern void OpenAccessDatabase     ( CHorzListBox &List1 );
    extern void ProviderProperties     ( CHorzListBox &List1 );
    extern void CodeTemplate           ( CHorzListBox &List1 );
    extern void InputOutputReturnParams( CHorzListBox &List1 );

    // Error/Exception Handlers
    extern HRESULT AdoErrorEx    (                   CHorzListBox &List1, ADODB::_ConnectionPtr Conn1 );
    extern void    MfcErrorEx    ( CException *e,    CHorzListBox &List1, ADODB::_ConnectionPtr Conn1 );
    extern void    Win32ErrorEx  ( SEH_Exception &e, CHorzListBox &List1, ADODB::_ConnectionPtr Conn1 );
    extern void    UnknownErrorEx(                   CHorzListBox &List1, ADODB::_ConnectionPtr Conn1 );
    extern void    ImportErrorEx ( _com_error &e,    CHorzListBox &List1, ADODB::_ConnectionPtr Conn1 );

#endif