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();

转载于:https://www.cnblogs.com/zzili/archive/2012/12/06/6663247.html