ado problem

Question

pConnection->Open(strCnn,"","",adConnectUnspecified);
strSql="SELECT Q.Train_id FROM RoutineRecord Q ,RoutineRecord W WHERE Q.Station_name=\""+strQ+"\" AND Q.Train_id=W.Train_id AND W.Station_name=\""+strZ+"\" AND W.Seq>Q.Seq AND W.Arrive_time BETWEEN '"+from+"' AND '"+to+"'";pRecordset->Open((_bstr_t)strSql,_variant_t((IDispatch*)pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);//调试时
strSql的值为
SELECT Q.Train_id FROM RoutineRecord Q ,RoutineRecord W WHERE Q.Station_name="上海" AND Q.Train_id=W.Train_id AND W.Station_name="北京" AND W.Seq>Q.Seq AND W.Arrive_time BETWEEN '12' AND '16'出错信息
First-chance exception in test1.exe (KERNEL32.DLL): 0xE06D7363: Microsoft C++ Exception.
The program 'D:\WorkDir\查询函数\Debug\test1.exe' has exited with code 0 (0x0).