在VC中通过ODBC连MYSQL数据库时出现的问题,紧急求助!!
MYSQL安装在linux服务器上,客户机在windows平台上通过ODBC来操作数据库的数据内容。
1.在ODBC administration中已成功配置ODBC,而且测试连接成功!
2.然而在VC中执行SQL语句时抛出异常,代码(含注释)如下:
(Unhandle exception in DBTest.exe(KERNEL32.DLL):0xE06D7363:Microsoft C++ Exception)
CDatabase *db1 = new CDatabase();
db1->Open("gpsdemo", false, false,
_T("ODBC;"), true);
//return 1; database open successfully
db1->IsOpen();
//this statement return true
CRecordset *rs = new CRecordset(db1);
// CRecordset object create successfully
CString strCmd = "SELECT Longitude , Latitude FROM LOGS";
//LOGS is a table in database gpsdemo
try{
rs->Open(AFX_DB_USE_DEFAULT_TYPE,
strCmd,
CRecordset::none);
// exception occours, and that catch statement didn't work
// why??
}
catch (CDBException &e) {
char str[200];
e.GetErrorMessage(str, 100, NULL);
}
catch (CMemoryException &e) {
char str[200];
e.GetErrorMessage(str, 100, NULL);
}
望各位高人帮小弟看看到底是哪里出了问题,若能贴出实例代码,则更是感激不尽啊!!~~