Guest phuocha_tnc Report post Posted 03/07/2005 04:12 AM Hi Admin, I have using Query database Module with SQL Server Database and I declared odbc Connect string like Help (Database Query). I also declared DNS with the same DNS name. Please view this attachment and help me. Thanks, Trace Log: 104924.89 0 callstate OFFERING 65979 0 4 104924.89 0 Answer the call at 3/7/2005 10:49:24 AM 104924.89 0 lineAnswer(65979) => 65962 104924.89 0 ring 1 104924.91 0 callstate ACCEPTED 65979 0 0 104928.05 0 tapi Reply (LineEvReply) ok 65962 0 104928.05 0 callstate CONNECTED 65979 0 0 104928.05 0 callstate CONNECTED 65979,0,0 104928.06 0 WorkingModeTAPI@Connected= 104928.06 0 WorkingModeScript@Connected= 104928.06 0 Inband detection not enabled 104928.08 0 StartLoadedVgs at 3/7/2005 10:49:28 AM 104928.08 0 AddRVns [scriptsPath]{C:\Tra_cuu_TK\DienThoai\} 104928.08 0 AddRVns [scriptPath]{C:\Tra_cuu_TK\DienThoai} 104928.09 0 rv add [$RV_STARTTIME]{3/7/2005 10:49:28 AM} 104928.09 0 rv add [$RV_DEVICEID]{0} 104928.11 0 rv add [$RV_CIDNAME]{} 104928.11 0 AddRVns [PathApp]{C:\Program Files\VoiceGuide\} 104928.13 0 rv add [$RV_CIDNUMBER]{} 104928.13 0 timer clear 104928.17 0 [inputCC] Number Input 104928.22 0 [inputCC] Playing (Record\Input_cc.wav) 104928.27 0 play set playid=726828 104928.63 0 PlaySoundStart ok [C:\Tra_cuu_TK\DienThoai\Record\Input_cc.wav] 104928.67 0 timer clear 104928.72 0 wa(19543,72682800) 104929.84 0 dtmf 1 (65979,49,2) 104929.89 0 ScriptEventCode 49 iLineState=1300 104929.94 0 LsGetNbrsPlayWelcMsg 1 104930.06 0 PlaySoundStop err=0 104930.11 0 [inputCC] Number Input 1 104930.16 0 path {1} not found 104930.20 0 ScriptEventCode 35 iLineState=1301 104930.25 0 LsGetNbrsRxDigits # 104930.30 0 timer clear 104930.34 0 rv add [inputCC]{1} 104930.39 0 path {1} not found 104930.44 0 AddRVns [inputCC_PathTaken]{success} 104930.48 0 timer clear 104930.53 0 [input_Nhom_LH] Number Input 104930.58 0 [input_Nhom_LH] Playing (Record\Input_Nhom_LH.wav) 104930.63 0 play set playid=729187 104930.98 0 PlaySoundStart ok [C:\Tra_cuu_TK\DienThoai\Record\Input_Nhom_LH.wav] 104931.03 0 timer clear 104931.08 0 wa(23302,72918700) 104932.83 0 dtmf 8 (65979,56,2) 104932.88 0 ScriptEventCode 56 iLineState=1300 104932.92 0 LsGetNbrsPlayWelcMsg 8 104933.05 0 PlaySoundStop err=0 104933.09 0 [input_Nhom_LH] Number Input 8 104933.14 0 path {8} not found 104933.19 0 timer set 10 EV_TIMEOUT_GOTOMODULE 104933.23 0 dtmf # (65979,35,2) 104933.28 0 ScriptEventCode 35 iLineState=1301 104933.33 0 LsGetNbrsRxDigits # 104933.38 0 timer clear 104933.42 0 rv add [input_Nhom_LH]{8} 104933.47 0 path {8} not found 104933.52 0 AddRVns [input_Nhom_LH_PathTaken]{success} 104933.56 0 timer clear 104933.61 0 [input_Ten_LH] Number Input 104933.66 0 rv replace start: [Record\$RV[input_Nhom_LH].wav] 104933.70 0 rv ns [PathSysVoice]{}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[scriptsPath]{C:\Tra_cuu_TK\DienThoai\}[scriptPath]{C:\Tra_cuu_TK\DienThoai}[$RV_STARTTIME]{3/7/2005 10:49:28 AM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[inputCC]{1}[inputCC_PathTaken]{success}[input_Nhom_LH]{8}[i put_Nhom_LH_PathTaken]{success} 104933.75 0 rv replace end: [Record\8.wav] 104933.78 0 [input_Ten_LH] Playing (Record\8.wav) 104933.83 0 play set playid=732390 104934.19 0 PlaySoundStart ok [C:\Tra_cuu_TK\DienThoai\Record\8.wav] 104934.23 0 timer clear 104934.28 0 wa(11273,73239000) 104935.45 0 dtmf 1 (65979,49,2) 104935.50 0 ScriptEventCode 49 iLineState=1300 104935.55 0 LsGetNbrsPlayWelcMsg 1 104935.67 0 PlaySoundStop err=0 104935.72 0 [input_Ten_LH] Number Input 1 104935.77 0 path {1} not found 104935.81 0 timer set 10 EV_TIMEOUT_GOTOMODULE 104935.86 0 dtmf # (65979,35,2) 104935.91 0 ScriptEventCode 35 iLineState=1301 104935.95 0 LsGetNbrsRxDigits # 104936.00 0 timer clear 104936.05 0 rv add [input_Ten_LH]{1} 104936.09 0 path {1} not found 104936.14 0 AddRVns [input_Ten_LH_PathTaken]{success} 104936.19 0 timer clear 104936.23 0 [inputSoTK] Number Input 104936.28 0 [inputSoTK] Playing (Record\Input_SoTK.wav) 104936.33 0 play set playid=734890 104936.67 0 PlaySoundStart ok [C:\Tra_cuu_TK\DienThoai\Record\Input_SoTK.wav] 104936.72 0 timer clear 104936.77 0 wa(6512,73489000) 104937.73 0 dtmf 1 (65979,49,2) 104937.78 0 ScriptEventCode 49 iLineState=1300 104937.83 0 LsGetNbrsPlayWelcMsg 1 104937.95 0 PlaySoundStop err=0 104938.00 0 [inputSoTK] Number Input 1 104938.05 0 path {1} not found 104938.09 0 timer set 10 EV_TIMEOUT_GOTOMODULE 104938.27 0 dtmf # (65979,35,2) 104938.31 0 ScriptEventCode 35 iLineState=1301 104938.36 0 LsGetNbrsRxDigits # 104938.41 0 timer clear 104938.45 0 rv add [inputSoTK]{1} 104938.50 0 path {1} not found 104938.55 0 AddRVns [inputSoTK_PathTaken]{success} 104938.59 0 timer clear 104938.64 0 [iF] Evaluate [$RV[inputCC]] 104938.69 0 rv replace start: [$RV[inputCC]] 104938.73 0 rv ns [PathSysVoice]{}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[scriptsPath]{C:\Tra_cuu_TK\DienThoai\}[scriptPath]{C:\Tra_cuu_TK\DienThoai}[$RV_STARTTIME]{3/7/2005 10:49:28 AM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[inputCC]{1}[inputCC_PathTaken]{success}[input_Nhom_LH]{8}[i put_Nhom_LH_PathTaken]{success}[input_Ten_LH]{1}[input_Ten_LH_PathTaken]{success [inputSoTK]{1}[inputSoTK_PathTaken]{success} 104938.78 0 rv replace end: [1] 104938.83 0 .Eval(1) 104938.88 0 AddRVns [iF_Input]{1} 104938.92 0 AddRVns [iF]{1} 104938.97 0 Eval Expr result:[1] 104939.02 0 timer clear 104939.06 0 [ccBienHoa] DB Query 104939.11 0 db ODBC mode used 104939.59 0 rv replace start (strlen>500) 104939.64 0 rv ns [PathSysVoice]{}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[scriptsPath]{C:\Tra_cuu_TK\DienThoai\}[scriptPath]{C:\Tra_cuu_TK\DienThoai}[$RV_STARTTIME]{3/7/2005 10:49:28 AM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[inputCC]{1}[inputCC_PathTaken]{success}[input_Nhom_LH]{8}[i put_Nhom_LH_PathTaken]{success}[input_Ten_LH]{1}[input_Ten_LH_PathTaken]{success [inputSoTK]{1}[inputSoTK_PathTaken]{success}[iF_Input]{1}[iF]{1} 104939.67 0 db About to execute a Retrieve type operation [select Pass_Num,bosung_GT from DTokhaiMD_1 where SoTK=1 and Ma_LH= IIf(8=1,'NDT', IIf(8=2,'NGC', IIf(8=3,'NKD', IIf(8=4,'NSX', IIf(8=5,'NTA', IIf(8=6,'NDT', IIf(8=7,'XGC', IIf(8=8,'XKD', IIf(8=9,'XSX','XTA')))))))))+ IIf(1=1,'01',IIf(1=2,'02', IIf(1=3,'03',IIf(1=4,'04', IIf(1=5,'05',IIf(1=6,'06', IIf(1=7,'07',IIf(1=8,'08', IIf(1=9,'09',1)))))))));] 104939.78 0 OpenRecordset: 3146:ODBC--call failed. 104939.83 0 path {0} not found 104939.88 0 path {} not found 104939.92 0 timer clear 104939.97 0 [Error_SoTK] Playing 104940.02 0 [Error_SoTK] Playing (Record\Error_SoTK.wav) 104940.06 0 play set playid=738625 104940.41 0 PlaySoundStart ok [C:\Tra_cuu_TK\DienThoai\Record\Error_SoTK.wav] 104940.45 0 timer clear 104940.50 0 RunModule PLAY end 104940.55 0 wa(7264,73862500) 104942.33 0 dtmf # (65979,35,2) 104942.38 0 ScriptEventCode 35 iLineState=1100 104942.42 0 LsPlayMsg # 104942.47 0 path {#} not found 104944.16 0 btn Hangup on line 0 104944.20 0 ScriptEventCode 9001 iLineState=1100 104944.25 0 LsPlayMsg EV_TIMEOUT_HANGUP 104944.30 0 rv add [Hangup Time]{3/7/2005 10:49:44 AM} 104944.34 0 Hanging up call... 104944.39 0 RecSoundStop ok 104944.53 0 PlaySoundStop err=0 104944.58 0 timer set 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP 104944.63 0 fnHangupCall end 104945.22 0 callstate DISCONNECTED 65979 1 0 104945.27 0 ScriptEventCode 9250 iLineState=900 104945.31 0 LsAwaitingCalls EV_REMOTEPARTY_DISCONNECT 104945.36 0 rv add [Hangup Time]{3/7/2005 10:49:45 AM} 104945.41 0 Hanging up call... 104945.45 0 RecSoundStop ok 104945.50 0 PlaySoundStop err=0 104945.55 0 timer set 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP 104945.59 0 fnHangupCall end 104945.64 0 callstate IDLE 65979 0 0 104945.69 0 WorkingMode@Idle= 104945.73 0 timer clear 104945.78 0 timer set 1 EV_TIMEOUT_TIMETOREINITLINE 104945.83 0 tapi Reply (LineEvReply) ok 65945 0 104945.88 0 tapi Reply (LineEvReply) ok 65928 0 104946.91 0 timer fired EV_TIMEOUT_TIMETOREINITLINE 104946.94 0 ScriptEventCode 9008 iLineState=900 104946.98 0 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE 104947.03 0 ReinitTelephony due to IDLE 104947.09 0 tapic lineDeallocateCall(MainCall:65979) 0 104947.14 0 lineOpen(0)=> 104947.19 0 Waiting for a call... 104947.23 0 LineHandle=65911 104947.30 0 timer set 3 EV_TIMEOUT_ATERIDLE_ALLOWOUT 104948.08 0 dial start any summary:|0:rdy=0| 104949.13 0 dial start any summary:|0:rdy=0| 104950.23 0 dial start any summary:|0:rdy=0| 104951.22 0 timer fired EV_TIMEOUT_ATERIDLE_ALLOWOUT 104951.33 0 ScriptEventCode 9013 iLineState=900 105017.41 0 sys cleanup Start 105017.59 0 sys cleanup End 110620.63 0 callstate OFFERING 65860 0 4 110620.63 0 Answer the call at 3/7/2005 11:06:20 AM 110620.63 0 lineAnswer(65860) => 65843 110620.63 0 ring 1 110620.64 0 callstate ACCEPTED 65860 0 0 110623.77 0 tapi Reply (LineEvReply) ok 65843 0 110623.78 0 callstate CONNECTED 65860 0 0 110623.78 0 callstate CONNECTED 65860,0,0 110623.78 0 WorkingModeTAPI@Connected= 110623.78 0 WorkingModeScript@Connected= 110623.78 0 Inband detection not enabled 110623.78 0 StartLoadedVgs at 3/7/2005 11:06:23 AM 110623.78 0 AddRVns [scriptsPath]{C:\Tra_cuu_TK\DienThoai\} 110623.78 0 AddRVns [scriptPath]{C:\Tra_cuu_TK\DienThoai} 110623.78 0 rv add [$RV_STARTTIME]{3/7/2005 11:06:23 AM} 110623.78 0 rv add [$RV_DEVICEID]{0} 110623.78 0 rv add [$RV_CIDNAME]{} 110623.78 0 AddRVns [PathApp]{C:\Program Files\VoiceGuide\} 110623.78 0 rv add [$RV_CIDNUMBER]{} 110623.78 0 timer clear 110623.80 0 [inputCC] Number Input 110623.80 0 [inputCC] Playing (Record\Input_cc.wav) 110623.80 0 play set playid=742359 110624.09 0 PlaySoundStart ok [C:\Tra_cuu_TK\DienThoai\Record\Input_cc.wav] 110624.09 0 timer clear 110624.09 0 wa(19543,74235900) 110643.70 0 wb(74235900) 110643.77 0 play end current play (playid=742359) 110643.78 0 ScriptEventCode 8001 iLineState=1300 110643.78 0 LsGetNbrsPlayWelcMsg EV_PLAY_FINISHED 110643.78 0 timer set 10 EV_TIMEOUT_HANGUP 110643.78 0 timer set 10 EV_TIMEOUT_GOTOMODULE 110654.61 0 timer fired EV_TIMEOUT_GOTOMODULE 110654.61 0 ScriptEventCode 9002 iLineState=1301 110654.61 0 LsGetNbrsRxDigits EV_TIMEOUT_GOTOMODULE 110654.61 0 rv add [inputCC]{} 110654.61 0 AddRVns [inputCC_PathTaken]{timeout} 110654.61 0 timer clear 110654.61 0 [Goodbye] Playing 110654.61 0 [Goodbye] Playing (Record\goodbye.wav) 110654.61 0 play set playid=773171 110654.91 0 PlaySoundStart ok [C:\Tra_cuu_TK\DienThoai\Record\goodbye.wav] 110654.91 0 timer clear 110654.91 0 RunModule PLAY end 110654.91 0 wa(3254,77317100) 110658.20 0 wb(77317100) 110658.30 0 play end current play (playid=773171) 110658.30 0 ScriptEventCode 8001 iLineState=1100 110658.30 0 LsPlayMsg EV_PLAY_FINISHED 110658.30 0 timer set 10 EV_TIMEOUT_HANGUP 110658.30 0 timer set 0 EV_TIMEOUT_GOTOMODULE 110658.30 0 ScriptEventCode 9002 iLineState=1101 110658.30 0 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE 110658.30 0 timer clear 110658.30 0 rv add [Hangup Time]{3/7/2005 11:06:58 AM} 110658.30 0 Hanging up call... [Hangup Module] 110658.31 0 RecSoundStop ok 110658.31 0 PlaySoundStop err=0 110658.31 0 timer set 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP 110658.31 0 fnHangupCall end 110658.92 0 callstate DISCONNECTED 65860 1 0 110658.92 0 ScriptEventCode 9250 iLineState=900 110658.92 0 LsAwaitingCalls EV_REMOTEPARTY_DISCONNECT 110658.92 0 rv add [Hangup Time]{3/7/2005 11:06:58 AM} 110658.92 0 Hanging up call... 110658.94 0 RecSoundStop ok 110658.94 0 PlaySoundStop err=0 110658.94 0 timer set 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP 110658.94 0 fnHangupCall end 110658.94 0 callstate IDLE 65860 0 0 110658.94 0 WorkingMode@Idle= 110658.94 0 timer clear 110658.95 0 timer set 1 EV_TIMEOUT_TIMETOREINITLINE 110658.95 0 tapi Reply (LineEvReply) ok 65826 0 110658.95 0 tapi Reply (LineEvReply) ok 65809 0 110659.94 0 timer fired EV_TIMEOUT_TIMETOREINITLINE 110659.94 0 ScriptEventCode 9008 iLineState=900 110659.94 0 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE 110659.94 0 ReinitTelephony due to IDLE 110659.94 0 tapic lineDeallocateCall(MainCall:65860) 0 110659.95 0 lineOpen(0)=> 110659.95 0 Waiting for a call... 110659.95 0 LineHandle=65792 110659.95 0 timer set 3 EV_TIMEOUT_ATERIDLE_ALLOWOUT 110700.09 0 dial start any summary:|0:rdy=0| 110701.09 0 dial start any summary:|0:rdy=0| 110702.09 0 dial start any summary:|0:rdy=0| 110703.09 0 dial start any summary:|0:rdy=0| 110703.23 0 timer fired EV_TIMEOUT_ATERIDLE_ALLOWOUT 110703.23 0 ScriptEventCode 9013 iLineState=900 TCTT_TK.vgs Share this post Link to post
SupportTeam Report post Posted 03/07/2005 05:08 AM Your SQL query is pretty complex: select Pass_Num,bosung_GT from DTokhaiMD_1 where SoTK=$RV[inputSoTK] and Ma_LH= IIf($RV[input_Nhom_LH]=1,'NDT', IIf($RV[input_Nhom_LH]=2,'NGC', IIf($RV[input_Nhom_LH]=3,'NKD', IIf($RV[input_Nhom_LH]=4,'NSX', IIf($RV[input_Nhom_LH]=5,'NTA', IIf($RV[input_Nhom_LH]=6,'NDT', IIf($RV[input_Nhom_LH]=7,'XGC', IIf($RV[input_Nhom_LH]=8,'XKD', IIf($RV[input_Nhom_LH]=9,'XSX','XTA')))))))))+ IIf($RV[input_Ten_LH]=1,'01',IIf($RV[input_Ten_LH]=2,'02', IIf($RV[input_Ten_LH]=3,'03',IIf($RV[input_Ten_LH]=4,'04', IIf($RV[input_Ten_LH]=5,'05',IIf($RV[input_Ten_LH]=6,'06', IIf($RV[input_Ten_LH]=7,'07',IIf($RV[input_Ten_LH]=8,'08', IIf($RV[input_Ten_LH]=9,'09',$RV[input_Ten_LH]))))))))); what happens when you try a simple SQL query, eg: select * from DTokhaiMD_1 (I assume that DTokhaiMD_1 is a valid table name) Share this post Link to post
Guest phuocha_tnc Report post Posted 03/07/2005 06:01 AM I already try export Sql database on Access database (.mdb) and It's success (including ODBC and direct .mdb) Pls help me. Thanks. Share this post Link to post
SupportTeam Report post Posted 03/07/2005 07:10 AM What happens when you try a simple SQL query on the database that you have a problems with using? eg: select * from DTokhaiMD_1 (I assume that DTokhaiMD_1 is a valid table name) Share this post Link to post
Guest phuocha_tnc Report post Posted 03/07/2005 08:23 AM On SQL Server 2000: - Database name: TCTK_BienHoa (table DtoKhaiMD, DToKhaiMD_1, ...) - DNS name: ccBienHoa (with default database name: TCTK_BienHoa, with true rules user:"sa", pass:"") - SQL Server still running. -------------------------------------- Lately, I have exported SQL database on Access database and setup DSN again. I run VG by 2 method: 1. use file ccBienHoa.mdb 2. use ODBC (data source is Microsoft Access) with name is: ccBienHoa All's success. Trace Log: 150051.06 6 tapi Reply (LineEvReply) ok 65621 0 150051.06 6 callstate CONNECTED 65638 0 0 150051.06 6 callstate CONNECTED 65638,0,0 150051.06 6 WorkingModeTAPI@Connected= 150051.06 6 WorkingModeScript@Connected= 150051.06 6 Inband detection not enabled 150051.06 6 StartLoadedVgs at 3/7/2005 3:00:51 PM 150051.08 6 AddRVns [scriptsPath]{C:\Tra_cuu_TK\DienThoai\} 150051.08 6 AddRVns [scriptPath]{C:\Tra_cuu_TK\DienThoai} 150051.08 6 rv add [$RV_STARTTIME]{3/7/2005 3:00:51 PM} 150051.08 6 rv add [$RV_DEVICEID]{6} 150051.09 6 rv add [$RV_CIDNAME]{} 150051.09 6 AddRVns [PathApp]{C:\Program Files\VoiceGuide\} 150051.09 6 rv add [$RV_CIDNUMBER]{} 150051.11 6 timer clear 150051.11 6 [inputCC] Number Input 150051.11 6 [inputCC] Playing (Record\Input_cc.wav) 150051.13 6 play set playid=716703 150051.52 6 PlaySoundStart ok [C:\Tra_cuu_TK\DienThoai\Record\Input_cc.wav] 150051.52 6 timer clear 150051.55 6 wa(19543,71670300) 150052.28 6 dtmf 1 (65638,49,2) 150052.30 6 ScriptEventCode 49 iLineState=1300 150052.33 6 LsGetNbrsPlayWelcMsg 1 150052.44 6 PlaySoundStop err=0 150052.47 6 [inputCC] Number Input 1 150052.48 6 path {1} not found 150052.52 6 ScriptEventCode 35 iLineState=1301 150052.55 6 LsGetNbrsRxDigits # 150052.58 6 timer clear 150052.61 6 rv add [inputCC]{1} 150052.63 6 path {1} not found 150052.66 6 AddRVns [inputCC_PathTaken]{success} 150052.72 6 timer clear 150052.73 6 [input_Nhom_LH] Number Input 150052.77 6 [input_Nhom_LH] Playing (Record\Input_Nhom_LH.wav) 150052.80 6 play set playid=718375 150053.13 6 PlaySoundStart ok [C:\Tra_cuu_TK\DienThoai\Record\Input_Nhom_LH.wav] 150053.16 6 timer clear 150053.17 6 wa(23302,71837500) 150054.39 6 dtmf 8 (65638,56,2) 150054.42 6 ScriptEventCode 56 iLineState=1300 150054.45 6 LsGetNbrsPlayWelcMsg 8 150054.58 6 PlaySoundStop err=0 150054.61 6 [input_Nhom_LH] Number Input 8 150054.63 6 path {8} not found 150054.66 6 timer set 10 EV_TIMEOUT_GOTOMODULE 150054.80 6 dtmf # (65638,35,2) 150054.83 6 ScriptEventCode 35 iLineState=1301 150054.84 6 LsGetNbrsRxDigits # 150054.88 6 timer clear 150054.91 6 rv add [input_Nhom_LH]{8} 150054.92 6 path {8} not found 150054.95 6 AddRVns [input_Nhom_LH_PathTaken]{success} 150055.02 6 timer clear 150055.03 6 [input_Ten_LH] Number Input 150055.06 6 rv replace start: [Record\$RV[input_Nhom_LH].wav] 150055.09 6 rv ns [PathSysVoice]{}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[scriptsPath]{C:\Tra_cuu_TK\DienThoai\}[scriptPath]{C:\Tra_cuu_TK\DienThoai}[$RV_STARTTIME]{3/7/2005 3:00:51 PM}[$RV_DEVICEID]{6}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[inputCC]{1}[inputCC_PathTaken]{success}[input_Nhom_LH]{8}[i put_Nhom_LH_PathTaken]{success} 150055.11 6 rv replace end: [Record\8.wav] 150055.14 6 [input_Ten_LH] Playing (Record\8.wav) 150055.17 6 play set playid=720750 150055.50 6 PlaySoundStart ok [C:\Tra_cuu_TK\DienThoai\Record\8.wav] 150055.52 6 timer clear 150055.55 6 wa(11273,72075000) 150056.88 6 dtmf 1 (65638,49,2) 150056.91 6 ScriptEventCode 49 iLineState=1300 150056.92 6 LsGetNbrsPlayWelcMsg 1 150057.03 6 PlaySoundStop err=0 150057.06 6 [input_Ten_LH] Number Input 1 150057.09 6 path {1} not found 150057.13 6 timer set 10 EV_TIMEOUT_GOTOMODULE 150057.34 6 dtmf # (65638,35,2) 150057.36 6 ScriptEventCode 35 iLineState=1301 150057.39 6 LsGetNbrsRxDigits # 150057.42 6 timer clear 150057.47 6 rv add [input_Ten_LH]{1} 150057.50 6 path {1} not found 150057.53 6 AddRVns [input_Ten_LH_PathTaken]{success} 150057.58 6 timer clear 150057.59 6 [inputSoTK] Number Input 150057.63 6 [inputSoTK] Playing (Record\Input_SoTK.wav) 150057.67 6 play set playid=723250 150058.00 6 PlaySoundStart ok [C:\Tra_cuu_TK\DienThoai\Record\Input_SoTK.wav] 150058.03 6 timer clear 150058.05 6 wa(6512,72325000) 150059.17 6 dtmf 1 (65638,49,2) 150059.19 6 ScriptEventCode 49 iLineState=1300 150059.22 6 LsGetNbrsPlayWelcMsg 1 150059.33 6 PlaySoundStop err=0 150059.36 6 [inputSoTK] Number Input 1 150059.38 6 path {1} not found 150059.41 6 timer set 10 EV_TIMEOUT_GOTOMODULE 150059.61 6 dtmf # (65638,35,2) 150059.64 6 ScriptEventCode 35 iLineState=1301 150059.67 6 LsGetNbrsRxDigits # 150059.70 6 timer clear 150059.72 6 rv add [inputSoTK]{1} 150059.75 6 path {1} not found 150059.78 6 AddRVns [inputSoTK_PathTaken]{success} 150059.83 6 timer clear 150059.84 6 [iF] Evaluate [$RV[inputCC]] 150059.88 6 rv replace start: [$RV[inputCC]] 150059.91 6 rv ns [PathSysVoice]{}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[scriptsPath]{C:\Tra_cuu_TK\DienThoai\}[scriptPath]{C:\Tra_cuu_TK\DienThoai}[$RV_STARTTIME]{3/7/2005 3:00:51 PM}[$RV_DEVICEID]{6}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[inputCC]{1}[inputCC_PathTaken]{success}[input_Nhom_LH]{8}[i put_Nhom_LH_PathTaken]{success}[input_Ten_LH]{1}[input_Ten_LH_PathTaken]{success [inputSoTK]{1}[inputSoTK_PathTaken]{success} 150059.94 6 rv replace end: [1] 150059.95 6 .Eval(1) 150059.98 6 AddRVns [iF_Input]{1} 150100.02 6 AddRVns [iF]{1} 150100.05 6 Eval Expr result:[1] 150100.09 6 timer clear 150100.11 6 [ccBienHoa] DB Query 150100.16 6 db ODBC mode used 150100.23 6 rv replace start (strlen>500) 150100.27 6 rv ns [PathSysVoice]{}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[scriptsPath]{C:\Tra_cuu_TK\DienThoai\}[scriptPath]{C:\Tra_cuu_TK\DienThoai}[$RV_STARTTIME]{3/7/2005 3:00:51 PM}[$RV_DEVICEID]{6}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[inputCC]{1}[inputCC_PathTaken]{success}[input_Nhom_LH]{8}[i put_Nhom_LH_PathTaken]{success}[input_Ten_LH]{1}[input_Ten_LH_PathTaken]{success [inputSoTK]{1}[inputSoTK_PathTaken]{success}[iF_Input]{1}[iF]{1} 150100.30 6 db About to execute a Retrieve type operation [select Pass_Num,bosung_GT from DTokhaiMD_1 where SoTK=1 and Ma_LH= IIf(8=1,'NDT', IIf(8=2,'NGC', IIf(8=3,'NKD', IIf(8=4,'NSX', IIf(8=5,'NTA', IIf(8=6,'NDT', IIf(8=7,'XGC', IIf(8=8,'XKD', IIf(8=9,'XSX','XTA')))))))))+ IIf(1=1,'01',IIf(1=2,'02', IIf(1=3,'03',IIf(1=4,'04', IIf(1=5,'05',IIf(1=6,'06', IIf(1=7,'07',IIf(1=8,'08', IIf(1=9,'09',1)))))))));] 150100.34 6 db [ccBienHoa] row count=1 150100.38 6 rv add [ccBienHoa_RowCount]{1} 150100.41 6 db get RecordsetGetRowsMax 150100.44 6 db get 999 records. (row count=1) 150100.47 6 db update RVs 150100.48 6 db about to close dbDbqDatabase 150100.55 6 db going down path [True] 150100.59 6 timer clear 150100.61 6 [Result1] Evaluate [$RV[ccBienHoa_1_1]] 150100.64 6 rv replace start: [$RV[ccBienHoa_1_1]] 150100.67 6 rv ns [PathSysVoice]{}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[scriptsPath]{C:\Tra_cuu_TK\DienThoai\}[scriptPath]{C:\Tra_cuu_TK\DienThoai}[$RV_STARTTIME]{3/7/2005 3:00:51 PM}[$RV_DEVICEID]{6}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[inputCC]{1}[inputCC_PathTaken]{success}[input_Nhom_LH]{8}[i put_Nhom_LH_PathTaken]{success}[input_Ten_LH]{1}[input_Ten_LH_PathTaken]{success [inputSoTK]{1}[inputSoTK_PathTaken]{success}[iF_Input]{1}[iF]{1}[ccBienHoa_RowCo nt]{1}[ccBienHoa_1_1]{1}[ccBienHoa_2_1]{0} 150100.70 6 rv replace end: [1] 150100.73 6 .Eval(1) 150100.77 6 AddRVns [Result1_Input]{1} 150100.80 6 AddRVns [Result1]{1} 150100.83 6 Eval Expr result:[1] 150100.88 6 timer clear 150100.89 6 [GD1] Playing 150100.92 6 [GD1] Playing (Record\GD1.wav) 150100.97 6 play set playid=726546 150101.28 6 PlaySoundStart ok [C:\Tra_cuu_TK\DienThoai\Record\GD1.wav] 150101.31 6 timer clear 150101.34 6 RunModule PLAY end 150101.39 6 wa(4507,72654600) 150104.50 0 btn Hangup on line 6 150104.53 6 ScriptEventCode 9001 iLineState=1100 150104.56 6 LsPlayMsg EV_TIMEOUT_HANGUP 150104.58 6 rv add [Hangup Time]{3/7/2005 3:01:04 PM} 150104.61 6 Hanging up call... 150104.67 6 RecSoundStop ok 150104.78 6 PlaySoundStop err=0 150104.80 6 timer set 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP 150104.83 6 fnHangupCall end 150105.47 6 callstate DISCONNECTED 65638 1 0 150105.50 6 ScriptEventCode 9250 iLineState=900 150105.53 6 LsAwaitingCalls EV_REMOTEPARTY_DISCONNECT 150105.55 6 rv add [Hangup Time]{3/7/2005 3:01:05 PM} 150105.58 6 Hanging up call... 150105.63 6 RecSoundStop ok 150105.67 6 PlaySoundStop err=0 150105.69 6 timer set 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP 150105.72 6 fnHangupCall end 150105.75 6 callstate IDLE 65638 0 0 150105.78 6 WorkingMode@Idle= 150105.81 6 timer clear 150105.84 6 timer set 1 EV_TIMEOUT_TIMETOREINITLINE 150105.88 6 tapi Reply (LineEvReply) ok 65604 0 150105.91 6 tapi Reply (LineEvReply) ok 65587 0 150107.34 6 timer fired EV_TIMEOUT_TIMETOREINITLINE 150107.41 6 ScriptEventCode 9008 iLineState=900 150107.47 6 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE 150107.56 6 ReinitTelephony due to IDLE 150107.64 6 tapic lineDeallocateCall(MainCall:65638) 0 150107.77 6 lineOpen(6)=> 150107.84 6 Waiting for a call... 150107.91 6 LineHandle=65570 150107.98 6 timer set 3 EV_TIMEOUT_ATERIDLE_ALLOWOUT 150108.64 0 dial start any summary:|6:rdy=0| 150109.70 0 dial start any summary:|6:rdy=0| 150110.77 0 dial start any summary:|6:rdy=0| 150111.83 0 dial start any summary:|6:rdy=0| 150112.03 6 timer fired EV_TIMEOUT_ATERIDLE_ALLOWOUT 150112.09 6 ScriptEventCode 9013 iLineState=900 150148.09 0 sys cleanup Start 150148.09 0 sys cleanup End Share this post Link to post
SupportTeam Report post Posted 03/07/2005 10:26 AM right... so do you still have a question/issue outstanding? Share this post Link to post
Guest phuocha_tnc Report post Posted 03/08/2005 01:25 AM Now, i want to use VG connect database by SQL Server 2k. I declared as in Voice Guide help but it's still error. Pls help me. Share this post Link to post
SupportTeam Report post Posted 03/08/2005 01:33 AM What happens when you try a simple SQL query on the database that you have a problems with using? eg: select * from DTokhaiMD_1 (I assume that DTokhaiMD_1 is a valid table name) Share this post Link to post
Guest phuocha_tnc Report post Posted 03/08/2005 02:33 AM if i try a simple SQL query on the database (select * from DTokhaiMD_1) It's OK, but i can't understand when i use SQL query below in Access database to be success. SQL query: select Pass_Num,bosung_GT from DTokhaiMD_1 where SoTK=$RV[inputSoTK] and Ma_LH= IIf($RV[input_Nhom_LH]=1,'NDT', IIf($RV[input_Nhom_LH]=2,'NGC', IIf($RV[input_Nhom_LH]=3,'NKD', IIf($RV[input_Nhom_LH]=4,'NSX', IIf($RV[input_Nhom_LH]=5,'NTA', IIf($RV[input_Nhom_LH]=6,'NDT', IIf($RV[input_Nhom_LH]=7,'XGC', IIf($RV[input_Nhom_LH]=8,'XKD', IIf($RV[input_Nhom_LH]=9,'XSX','XTA')))))))))+ IIf($RV[input_Ten_LH]=1,'01',IIf($RV[input_Ten_LH]=2,'02', IIf($RV[input_Ten_LH]=3,'03',IIf($RV[input_Ten_LH]=4,'04', IIf($RV[input_Ten_LH]=5,'05',IIf($RV[input_Ten_LH]=6,'06', IIf($RV[input_Ten_LH]=7,'07',IIf($RV[input_Ten_LH]=8,'08', IIf($RV[input_Ten_LH]=9,'09',$RV[input_Ten_LH]))))))))); Although both database are the same. ------------------ Because i only understand a little English, i hope so you'll understand them and help me. Thanks, Share this post Link to post
SupportTeam Report post Posted 03/08/2005 03:19 AM if i try a simple SQL query on the database (select * from DTokhaiMD_1) It's OK This looks like some sort of an SQLServer specific SQL query syntax problem, not an ODBC connectivity problem. I'd recommend you debug your SQL statement by gradually increasing complexity and seeing at which stage it breaks. VoiceGuide itself does not do any processing of the SQL statements - whatever is specified in script is just passed onto the database (after the RVs are replaced (if any)). If I were you I'd look closely at how the IIF command (which you use a lot of) is supported by SQLServr. Share this post Link to post
Guest phuocha_tnc Report post Posted 03/08/2005 03:55 AM Thanks your reply, Because I used this Sql query on Access database (which I had exported from Sql Server 2k) to be OK. I will check careful them again. In Query database, when it's check conection of database (eg: Sql Server), if Sql Server is not running, how do announce to the caller and hangup call? Share this post Link to post
SupportTeam Report post Posted 03/08/2005 07:24 AM if Sql Server is not running, how do announce to the caller and hangup call? Best way is to run a simple query which you know will always return something and if it does not return the expected data then the database must be down... Share this post Link to post
