adoutils.h

vc ADO 连接数据库

// ADOUTILS:  Header File for helper functions for manipulating ADO within 
//            Visual C++ via OLE SDK

#ifndef _ADOUTILS_H_
#define _ADOUTILS_H_


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

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

    // (shared) utility functions
    extern void     DumpProperty         ( CHorzListBox &List1, ADOConnection* Conn1, ADOProperties* Props1 );
    extern CString  GetPropertyAttributes( PropertyAttributesEnum e   );
    extern CString  GetType              ( int e );
    extern CString  CrackStrVariant      ( const COleVariant& 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, ADOConnection *Conn1 );
    extern void    MfcErrorEx    ( CException *e,    CHorzListBox &List1, ADOConnection *Conn1 );
    extern void    Win32ErrorEx  ( SEH_Exception &e, CHorzListBox &List1, ADOConnection *Conn1 );
    extern void    UnknownErrorEx(                   CHorzListBox &List1, ADOConnection *Conn1 );

#endif