CDatabase m_db;
// 取ODBC连接字符串
CString GetConnectString()
{
TCHAR szCurDir[512];
GetCurrentDirectory(512, szCurDir);
// 1. ODBC 数据源
// CString strConn = _T("DSN=test");
// 2. 文件数据源
//CString strConn = L"FILEDSN=";
//strConn += szCurDir;
//strConn += L"\\test.dsn";
// 3. 不用数据源
CString strConn = _T("Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=");
strConn += szCurDir;
strConn += _T("\\test.accdb;");
return strConn;
}
// 打开数据库
BOOL Open()
{
try
{
if (!m_db.OpenEx( GetConnectString(),
CDatabase::useCursorLib |
CDatabase::noOdbcDialog))
{
AfxMessageBox( _T("Open database failed"), MB_OK );
return FALSE;
}
m_rs.m_pDatabase = &m_db;
}
catch( CDBException *e )
{
//ReportError(e);
return FALSE;
}
return TRUE;
}