CString DbPath; DbPath=远程路径+"\\"; DbPath+="nitor.mdb"; try{ //Open a connection using the OLE DB Provider for Microsoft Jet. g_pConnection->Provider = "Microsoft.Jet.OLEDB.4.0"; g_pConnection->Open((_bstr_t)DbPath,"","",NULL); g_pRecordset->Open("Select * from Data",(IDispatch*)g_pConnection,adOpenDynamic,adLockOptimistic,adCmdText); g_pAlarmRecordset->Open("Select * from AlarmRecord",(IDispatch*)g_pConnection,adOpenDynamic,adLockOptimistic,adCmdText);
extern _RecordsetPtr g_pRecordset; //信息
extern _RecordsetPtr g_pAlarmRecordset; //信息
void InitDataBaseFile()
{
TESTHR(g_pConnection.CreateInstance(_uuidof(Connection))); TESTHR(g_pGpsRecordset.CreateInstance(_uuidof(Recordset)));
TESTHR(g_pAlarmRecordset.CreateInstance(_uuidof(Recordset)));
CString DbPath;
DbPath=远程路径+"\\";
DbPath+="nitor.mdb";
try{
//Open a connection using the OLE DB Provider for Microsoft Jet.
g_pConnection->Provider = "Microsoft.Jet.OLEDB.4.0";
g_pConnection->Open((_bstr_t)DbPath,"","",NULL); g_pRecordset->Open("Select * from Data",(IDispatch*)g_pConnection,adOpenDynamic,adLockOptimistic,adCmdText);
g_pAlarmRecordset->Open("Select * from AlarmRecord",(IDispatch*)g_pConnection,adOpenDynamic,adLockOptimistic,adCmdText);
}
catch(_com_error &e) //异常处理
{
if(g_pConnection) PrintProviderError(g_pConnection);
PrintComError(e);
}}
这些是我打开数据库所用的代码,大家看一下,怎样做改动才可以?