HRESULT hr;

     try

    {    

        hr  =  m_pConnection.CreateInstance( " ADODB.Connection " ); /// 创建Connection对象

         if (SUCCEEDED(hr))        {

            hr  =  m_pConnection -> Open( " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb " , "" , "" ,adModeUnknown); /// 连接数据库

             /// 上面一句中连接字串中的Provider是针对ACCESS2000环境的，对于ACCESS97,需要改为:Provider=Microsoft.Jet.OLEDB.3.51;  }

        }

    }

     catch (_com_error e) /// 捕捉异常

    {

        CString errormessage;

        errormessage.Format( " 连接数据库失败!\r\n错误信息:%s " ,e.ErrorMessage());

        AfxMessageBox(errormessage); /// 显示错误信息

         return  FALSE;

    } 

CString strSQL;

    HRESULT hr;

     try

    {    

        hr = m_pConnection.CreateInstance(__uuidof(Connection));

        m_pConnection -> CursorLocation = adUseClient;

        strSQL = " Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TEST;Data Source=yjm " ;    

         if (SUCCEEDED(hr))

        {

            hr = m_pConnection -> Open(_bstr_t(strSQL), "" , "" , - 1 );            

        }

    }

     catch (_com_error e) /// 捕捉异常

    {

        CString errormessage;

        errormessage.Format( " 连接数据库失败!\r\n错误信息:%s " ,e.ErrorMessage());

        AfxMessageBox(errormessage); /// 显示错误信息

         return  FALSE;

    } 

     // AfxMessageBox("connected~~");