mfc用odbc连接access

#include <afxdb.h> //以提供对CDatabase 类的支持  
#include <odbcinst.h>
 #pragma comment(lib,"odbccp32.lib") //为了使用ODBC API的函数 SQLConfigDataSource
#include   <odbcinst.h> 
CDatabase m_database;
//创建数据源
 SQLConfigDataSource(NULL,ODBC_ADD_SYS_DSN,"Microsoft Access Driver (*.mdb)","DSN=数据\0""DBQ=C:\\数据.mdb\0");
    ///打开数据库
 if(!m_database.Open( "数据", FALSE, FALSE, _T("ODBC;UID=JOES")))                               
 { 
 AfxMessageBox( "连接失败 "); 
     }       
 //创建表
 //CString strSQLexe="Create table test(iID int , tmJoin datetime, szName varchar(40),fTall float );";
 //m_database.ExecuteSQL(strSQLexe);
 //查询操作
 CRecordset *rs = new CRecordset(&m_database);
 CString   lpszSQL= "select   userName,userPass   from   admin"; 
    if(rs-> Open(CRecordset::forwardOnly,lpszSQL))   
 {
 CDBVariant varValue;
 while(!rs->IsEOF())
 {
 for(short index = 0; index < 2; index++)
 {
 rs->GetFieldValue(index, varValue);
 // do something with varValue
 AfxMessageBox(varValue.m_pstring->GetBuffer(2));
 }
 rs->MoveNext();
 }
 }
 rs->Close();
 m_database.Close();