sql server连接数据库 ado连接sql server

#pragma once

class COperaterDB
{
public:
COperaterDB(void);
public:
~COperaterDB(void);
public:
   _ConnectionPtr m_pConn;//数据库连接指针
   _RecordsetPtr m_pRec; //记录集指针
BOOL ConnectionDB();
BOOL CloseConnectionDB();
BOOL AdoState();
BOOL InsertRecord(const CString  &strSQL);
};
-------------------------------------------------------------------------------
#include "StdAfx.h"
#include "OperaterDB.h"
#include"MainFrm.h"

extern  CMainFrame  *m_pMainFrame ;
//extern CAccessControlApp theApp;
COperaterDB::COperaterDB(void)
{

HRESULT hr;

// 初始化 OLE 库
AfxOleInit();


try
{
hr=m_pConn.CreateInstance("ADODB.Connection");
 m_pRec.CreateInstance("ADODB.Recordset");

}
catch(_com_error e)
{
CString   errormessage;   
errormessage.Format("初始化数据库失败!\r\n错误信息:%s",e.ErrorMessage());  
AfxMessageBox(errormessage);///显示错误信息  

}

}

COperaterDB::~COperaterDB(void)
{

}
/*
CString SQL;
  char m_server[30],m_uid[30],m_pwd[30],m_DBName[30];
  try
  {
memset(m_server,0,sizeof(m_server));