TeleFlow Forums http://teleflow.org/phpbb/ |
|
sql statement http://teleflow.org/phpbb/viewtopic.php?f=10&t=566 |
Page 1 of 1 |
Author: | jazzb2009 [ Sun Feb 08, 2009 3:55 pm ] |
Post subject: | sql statement |
i have a database called menagerie, i have a table inside called list, with fields: number, value and date. using a get tt string, what sql statement should i use from teleflow to get the number fields out put to the console? |
Author: | Chris [ Mon Feb 09, 2009 10:37 am ] |
Post subject: | Re: sql statement |
I'm not sure what you are trying to accomplish, but I can suggest a couple things relating to what I think you might be after. If you are using a "Get TT String" step to get an input from the caller, it doesn't do anything with SQL. You can use it to get a TeleFlow variable, such as @TT_INPUT, then use that in a SQL Statement step, such as: SELECT value, date as MY_DATE FROM list WHERE number = @TT_INPUT I'm not sure what you are looking for with output to console. Do you wish to output a value to the TeleFlow Monitor? If so, set @SYS_DATA = @VALUE in a "Set Global Variable" step after running the "SQL Statement" and "SQL Fetch" steps to get your row. Feel free to clarify what you're after if I haven't touched on everything. |
Author: | jazzb2009 [ Tue Feb 10, 2009 5:10 am ] |
Post subject: | Re: sql statement |
thank you for your assistance, however the statement didnt work, I am trying to build an application similar to the ticket file in the lottery demonstration. e.g "Fast food restaurant having a promotion. to redeem your voucher, at the touch tone enter the voucher 4 digit number". I am looking for callers input, that will co-relate with the functions of the dbase file to output the voucher value back to the caller. I hope i have been able to properly explain. Thanks again. |
Author: | Chris [ Tue Feb 10, 2009 10:26 am ] |
Post subject: | Re: sql statement |
Well, I didn't necessarily intend that SQL statement to work... I wasn't even sure the table you described was anything other than an example. First off, you have to have an ODBC entry defined that points to the database or tables you are using, and you have to use a "DB Connect" step in your TeleFlow application to connect to it. When you run the TeleFlow Simulator to test, click the "Show Log" button and check for what went wrong. If you can't figure out what the problem is from the log, post it here. |
Author: | jazzb2009 [ Tue Feb 10, 2009 12:15 pm ] |
Post subject: | Re: sql statement |
My mistake i had thought that was the command, well i couldnt really figure it out so i will post it here. Thank you for your assistance. 2009/02/10 14:01:03.910: Loading language 'C:\Program Files\TeleFlow\Lang_English.dll' 2009/02/10 14:01:03.954: Setting system variable '@SYSDRIVE' to 'C:' 2009/02/10 14:01:03.957: Setting system variable '@SYSDIR' to '\Users\vixen\AppData\Roaming\TeleFlow\Applications' 2009/02/10 14:01:03.958: TeleFlow Application: C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\NewApplication.tap 2009/02/10 14:01:03.958: Ver: 0200 S/N: 00000 2009/02/10 14:01:03.959: TeleFlow Voice Database: C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Tam\Voice.dbf 2009/02/10 14:01:03.960: Voice file search path: None 2009/02/10 14:01:03.961: TeleFlow Procedure: > Tam\test.tam Ver: 0200 S/N: 00000 2009/02/10 14:01:03.963: TeleFlow Procedure: Tam\DbSet.tam Ver: 0200 S/N: 00000 2009/02/10 14:01:03.965: TeleFlow Procedure: Tam\DbRetry.tam Ver: 0200 S/N: 00000 2009/02/10 14:01:03.966: TeleFlow Procedure: Tam\InputMan.tam Ver: 0200 S/N: 00000 2009/02/10 14:01:03.968: TeleFlow Procedure: Tam\MM_MENU.tam Ver: 0200 S/N: 00000 2009/02/10 14:01:03.970: TeleFlow Procedure: Tam\Defaults.tam Ver: 0200 S/N: 00000 2009/02/10 14:01:03.973: TeleFlow Procedure: Tam\WaitForCall.tam Ver: 0200 S/N: 00000 2009/02/10 14:01:03.975: TeleFlow Procedure: Tam\Exit.tam Ver: 0200 S/N: 00000 2009/02/10 14:01:03.976: TeleFlow Procedure: Tam\MenuMan.tam Ver: 0200 S/N: 00000 2009/02/10 14:01:03.978: TeleFlow Procedure: Tam\TICKET.tam Ver: 0200 S/N: 00000 2009/02/10 14:01:03.980: TeleFlow Procedure: Tam\MenuSet.tam Ver: 0200 S/N: 00000 2009/02/10 14:01:03.981: Setting system variable '@SYSDRIVE' to 'C:' 2009/02/10 14:01:03.982: Setting system variable '@SYSDIR' to '\Users\vixen\AppData\Roaming\TeleFlow\Applications' 2009/02/10 14:01:03.982: Setting system variable '@P1' to '' 2009/02/10 14:01:03.983: Setting system variable '@P2' to '' 2009/02/10 14:01:03.984: Setting system variable '@P3' to '' 2009/02/10 14:01:03.984: Setting system variable '@P4' to '' 2009/02/10 14:01:03.985: Setting system variable '@P5' to '' 2009/02/10 14:01:03.985: Setting system variable '@P6' to '' 2009/02/10 14:01:03.986: Setting system variable '@P7' to '' 2009/02/10 14:01:03.986: Setting system variable '@P8' to '' 2009/02/10 14:01:03.987: Setting system variable '@P9' to '' 2009/02/10 14:01:03.987: Setting system variable '@PROMPT' to 'C:\Program Files\TeleFlow\Languages\English' 2009/02/10 14:01:03.988: Setting global variable '@VOLUME' to '0' 2009/02/10 14:01:03.988: Setting global variable '@TIMEOUT' to '3000' 2009/02/10 14:01:03.989: Setting system variable '@FAXQPTR' to '' 2009/02/10 14:01:03.989: Setting system variable '@PORT' to '1' 2009/02/10 14:01:03.990: Setting system variable '@CALL_LINE' to '' 2009/02/10 14:01:03.990: Setting system variable '@SPELLTONES' to '' 2009/02/10 14:01:03.991: Setting system variable '@RECORD_RESULT' to '' 2009/02/10 14:01:03.991: Setting global variable '@SYS_DATA' to '' 2009/02/10 14:01:03.992: Setting system variable '@CHAR_SOH' to '' 2009/02/10 14:01:03.999: Setting system variable '@CHAR_STX' to '' 2009/02/10 14:01:04.001: Setting system variable '@CHAR_ETX' to '' 2009/02/10 14:01:04.002: Setting system variable '@CHAR_EOT' to '' 2009/02/10 14:01:04.003: Setting system variable '@CHAR_ENQ' to '' 2009/02/10 14:01:04.004: Setting system variable '@CHAR_ACK' to '' 2009/02/10 14:01:04.004: Setting system variable '@CHAR_BEL' to '' 2009/02/10 14:01:04.005: Setting system variable '@CHAR_BS' to '' 2009/02/10 14:01:04.006: Setting system variable '@CHAR_TAB' to ' ' 2009/02/10 14:01:04.006: Setting system variable '@TAB' to ' ' 2009/02/10 14:01:04.007: Setting system variable '@CHAR_LF' to ' ' 2009/02/10 14:01:04.008: Setting system variable '@LINEFEED' to ' ' 2009/02/10 14:01:04.009: Setting system variable '@CHAR_VT' to '' 2009/02/10 14:01:04.010: Setting system variable '@CHAR_FF' to '' 2009/02/10 14:01:04.011: Setting system variable '@FORMFEED' to '' 2009/02/10 14:01:04.011: Setting system variable '@CHAR_CR' to ' ' 2009/02/10 14:01:04.012: Setting system variable '@CHAR_SO' to '' 2009/02/10 14:01:04.013: Setting system variable '@CHAR_SI' to '' 2009/02/10 14:01:04.013: Setting system variable '@CHAR_DLE' to '' 2009/02/10 14:01:04.014: Setting system variable '@CHAR_DC1' to '' 2009/02/10 14:01:04.015: Setting system variable '@CHAR_DC2' to '' 2009/02/10 14:01:04.015: Setting system variable '@CHAR_DC3' to '' 2009/02/10 14:01:04.016: Setting system variable '@CHAR_DC4' to '' 2009/02/10 14:01:04.017: Setting system variable '@CHAR_NAK' to '' 2009/02/10 14:01:04.018: Setting system variable '@CHAR_SYN' to '' 2009/02/10 14:01:04.018: Setting system variable '@CHAR_ETB' to '' 2009/02/10 14:01:04.019: Setting system variable '@CHAR_CAN' to '' 2009/02/10 14:01:04.021: Setting system variable '@CHAR_EM' to '' 2009/02/10 14:01:04.022: Setting system variable '@CHAR_SUB' to '' 2009/02/10 14:01:04.022: Setting system variable '@CHAR_ESC' to '' 2009/02/10 14:01:04.023: Setting system variable '@CHAR_FS' to '' 2009/02/10 14:01:04.023: Setting system variable '@CHAR_GS' to '' 2009/02/10 14:01:04.024: Setting system variable '@CHAR_RS' to '' 2009/02/10 14:01:04.024: Setting system variable '@CHAR_US' to '' 2009/02/10 14:01:04.025: Setting system variable '@SPACE' to ' ' 2009/02/10 14:01:04.026: Setting system variable '@CHAR_DEL' to '' 2009/02/10 14:01:04.026: Setting system variable '@HANGUP' to '' 2009/02/10 14:01:04.027: Setting system variable '@FATAL' to '' 2009/02/10 14:01:04.027: Setting system variable '@CALL_SEIZED' to '' 2009/02/10 14:01:04.028: Setting system variable '@CALL_START' to '' 2009/02/10 14:01:04.028: Setting system variable '@CALL_END' to '' 2009/02/10 14:01:04.029: Setting system variable '@CALL_ELAPSE' to '' 2009/02/10 14:01:04.030: Setting system variable '@WEEKDAY' to '' 2009/02/10 14:01:04.030: Setting system variable '@DATE' to '' 2009/02/10 14:01:04.031: Setting system variable '@TIME' to '' 2009/02/10 14:01:04.031: Setting system variable '@UNIX_TIME' to '' 2009/02/10 14:01:04.032: Setting system variable '@HOOK_STATUS' to '' 2009/02/10 14:01:04.033: Setting system variable '@APPID' to '1001' 2009/02/10 14:01:04.034: Setting system variable '@CALLOUT_RESULT' to '' 2009/02/10 14:01:04.034: Setting system variable '@CALLOUT_REASON' to '' 2009/02/10 14:01:04.035: Setting system variable '@TRUNK_TYPE' to '' 2009/02/10 14:01:04.035: Setting system variable '@SYS_CALLREF' to '' 2009/02/10 14:01:04.036: Initializing... 2009/02/10 14:01:04.037: Initialization done 2009/02/10 14:01:04.039: ==>test 2009/02/10 14:01:04.039: [1] START 2009/02/10 14:01:04.041: [3] Global Event 2009/02/10 14:01:04.042: Label is 'APPLICATION_ERROR' 2009/02/10 14:01:04.044: Setting system variable '@FATAL' to 'APPLICATION_ERROR' 2009/02/10 14:01:04.045: [4] Global Event 2009/02/10 14:01:04.046: Label is 'CALLER_GONE' 2009/02/10 14:01:04.047: Setting system variable '@HANGUP' to 'CALLER_GONE' 2009/02/10 14:01:04.048: [5] DB Connect 2009/02/10 14:01:04.049: Parameters is 'DSN=dBASE Files' 2009/02/10 14:01:04.049: ConnectString: DSN=dBASE Files 2009/02/10 14:01:04.124: SQL Error State: HY092 Native Error Code: 56 ODBC Error: [Microsoft][ODBC dBASE Driver]Invalid attribute/option identifier 2009/02/10 14:01:04.126: [10] Run Flowchart 2009/02/10 14:01:04.127: Flowchart is 'DEFAULTS' 2009/02/10 14:01:04.128: test==> Defaults 2009/02/10 14:01:04.129: [1] START 2009/02/10 14:01:04.130: [122] Set Language 2009/02/10 14:01:04.131: Location of prompt recordings is '' 2009/02/10 14:01:04.132: Language module 'C:\Program Files\TeleFlow\Lang_English.dll' already loaded 2009/02/10 14:01:04.133: Setting system variable '@PROMPT' to 'C:\Program Files\TeleFlow\Languages\English' 2009/02/10 14:01:04.134: [86] Set Global Variable 2009/02/10 14:01:04.135: Setting global variable '@MENULOOP' to '3' 2009/02/10 14:01:04.136: [96] Set Global Variable 2009/02/10 14:01:04.137: Setting global variable '@DBLOOP' to '4' 2009/02/10 14:01:04.138: [100] Set Global Variable 2009/02/10 14:01:04.139: Setting global variable '@PLAY_VOLUME' to '0' 2009/02/10 14:01:04.141: [102] Set Global Variable 2009/02/10 14:01:04.142: Setting global variable '@REC_VOLUME' to '0' 2009/02/10 14:01:04.143: [107] Set Global Variable 2009/02/10 14:01:04.144: Setting global variable '@SYSLOC' to 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications' 2009/02/10 14:01:04.145: [104] Connect Point 2009/02/10 14:01:04.146: [105] Connect Point 2009/02/10 14:01:04.147: [88] Set Global Variable 2009/02/10 14:01:04.148: Setting global variable '@COUNTER' to '0' 2009/02/10 14:01:04.149: [98] Set Global Variable 2009/02/10 14:01:04.150: Setting global variable '@DB_COUNTER' to '0' 2009/02/10 14:01:04.151: [109] Set Global Variable 2009/02/10 14:01:04.152: Setting global variable '@VOLUME' to '0' 2009/02/10 14:01:04.155: [111] Compare 2009/02/10 14:01:04.156: First Value '@TRUNK_TYPE' evaluates to 'SIMULATED' 2009/02/10 14:01:04.157: Second Value is 'ANALOG' 2009/02/10 14:01:04.158: @TRUNK_TYPE = ANALOG? 2009/02/10 14:01:04.158: (string):SIMULATED = (string):ANALOG? 2009/02/10 14:01:04.159: FALSE 2009/02/10 14:01:04.159: [116] Set Global Variable 2009/02/10 14:01:04.160: Setting global variable '@PICKUP_RINGCOUNT' to '0' 2009/02/10 14:01:04.161: [118] Set Global Variable 2009/02/10 14:01:04.162: Setting global variable '@CONNECTION_DELAY' to '500' 2009/02/10 14:01:04.163: [129] Set Global Variable 2009/02/10 14:01:04.164: Setting global variable '@HANG_WAIT' to '1000' 2009/02/10 14:01:04.164: [131] Connect Point 2009/02/10 14:01:04.166: [2] FINISH 2009/02/10 14:01:04.167: test<==Defaults 2009/02/10 14:01:04.167: [18] Compare 2009/02/10 14:01:04.169: First Value '@HOOK_STATUS' evaluates to 'ON-HOOK' 2009/02/10 14:01:04.169: Second Value is 'OFF-HOOK' 2009/02/10 14:01:04.173: @HOOK_STATUS = OFF-HOOK? 2009/02/10 14:01:04.173: (string):ON-HOOK = (string):OFF-HOOK? 2009/02/10 14:01:04.174: FALSE 2009/02/10 14:01:04.174: [23] Set Local Variable 2009/02/10 14:01:04.175: Setting local variable '@FINISH_CALL_ACTION' to 'NEXT_CALL' 2009/02/10 14:01:04.176: [32] Run Flowchart 2009/02/10 14:01:04.177: Flowchart is 'WaitForCall' 2009/02/10 14:01:04.178: test==> WaitForCall 2009/02/10 14:01:04.179: [1] START 2009/02/10 14:01:04.180: [10] Wait 2009/02/10 14:01:04.182: Delay '@HANG_WAIT' evaluates to '1000' 2009/02/10 14:01:04.183: Waiting 1000 milliseconds 2009/02/10 14:01:05.184: numWaitObjects = 5, WAIT_OBJECT_0 + 2 = 2, ret = 2 - @@@ 2009/02/10 14:01:05.185: [7] Compare 2009/02/10 14:01:05.186: First Value '@TRUNK_TYPE' evaluates to 'SIMULATED' 2009/02/10 14:01:05.187: Second Value is 'ANALOG' 2009/02/10 14:01:05.187: @TRUNK_TYPE = ANALOG? 2009/02/10 14:01:05.188: (string):SIMULATED = (string):ANALOG? 2009/02/10 14:01:05.189: FALSE 2009/02/10 14:01:05.189: [5] Wait for Call 2009/02/10 14:01:05.190: TIMEOUT is '0' 2009/02/10 14:01:05.191: WARNING: TIMEOUT '0' evaluates to 0 and is interpreted as no timeout 2009/02/10 14:01:05.192: Rings '@PICKUP_RINGCOUNT' evaluates to '0' 2009/02/10 14:01:05.192: Connection Delay '@CONNECTION_DELAY' evaluates to '500' 2009/02/10 14:01:06.693: Wait for 0 rings and then pickup 2009/02/10 14:01:11.607: Setting global variable '@CALLER_ID' to '' 2009/02/10 14:01:11.609: Setting global variable '@DNIS' to '' 2009/02/10 14:01:11.610: Connection delay: 500 ms 2009/02/10 14:01:12.111: [2] FINISH 2009/02/10 14:01:12.112: test<==WaitForCall 2009/02/10 14:01:12.113: [7] Run Flowchart 2009/02/10 14:01:12.115: Flowchart is 'MM_MENU' 2009/02/10 14:01:12.117: test==> MM_MENU 2009/02/10 14:01:12.118: [100] START 2009/02/10 14:01:12.119: [217] Play 2009/02/10 14:01:12.120: Script code is 'new' 2009/02/10 14:01:12.122: Script code 'new' corresponds to file 'Vox\Eng\Scripts\new.wav' 2009/02/10 14:01:12.125: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\new.wav' 2009/02/10 14:01:19.797: [156] Clear TT 2009/02/10 14:01:19.799: [209] Play 2009/02/10 14:01:19.800: Script code is 'mm' 2009/02/10 14:01:19.801: Script code 'mm' corresponds to file 'Vox\Eng\Scripts\mm.wav' 2009/02/10 14:01:19.802: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\mm.wav' 2009/02/10 14:01:23.943: [105] Play 2009/02/10 14:01:23.944: Script code is 'mmA' 2009/02/10 14:01:23.945: Script code 'mmA' corresponds to file 'Vox\Eng\Scripts\mm02.wav' 2009/02/10 14:01:23.946: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\mm02.wav' 2009/02/10 14:01:27.413: [107] Play 2009/02/10 14:01:27.415: Script code is 'PRESS01' 2009/02/10 14:01:27.417: Script code 'PRESS01' corresponds to file 'Vox\Eng\Scripts\press01.wav' 2009/02/10 14:01:27.418: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\press01.wav' 2009/02/10 14:01:28.891: [109] Play 2009/02/10 14:01:28.894: Script code is 'TT' 2009/02/10 14:01:28.895: Script code 'TT' corresponds to file 'Vox\Eng\Scripts\TT.wav' 2009/02/10 14:01:28.896: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\TT.wav' 2009/02/10 14:01:29.323: Interrupted by touch tone 2009/02/10 14:01:29.347: [111] Play 2009/02/10 14:01:29.349: Script code is 'PRESS02' 2009/02/10 14:01:29.350: Script code 'PRESS02' corresponds to file 'Vox\Eng\Scripts\press02.wav' 2009/02/10 14:01:29.350: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\press02.wav' 2009/02/10 14:01:29.351: Interrupted! 2009/02/10 14:01:29.351: [117] Play 2009/02/10 14:01:29.352: Script code is 'LG' 2009/02/10 14:01:29.353: Script code 'LG' corresponds to file 'Vox\Eng\Scripts\LG.wav' 2009/02/10 14:01:29.354: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\LG.wav' 2009/02/10 14:01:29.354: Interrupted! 2009/02/10 14:01:29.355: [119] Play 2009/02/10 14:01:29.356: Script code is 'PRESS03' 2009/02/10 14:01:29.357: Script code 'PRESS03' corresponds to file 'Vox\Eng\Scripts\press03.wav' 2009/02/10 14:01:29.358: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\press03.wav' 2009/02/10 14:01:29.358: Interrupted! 2009/02/10 14:01:29.359: [129] Menu 2009/02/10 14:01:29.360: TIMEOUT is '' 2009/02/10 14:01:29.362: Empty TIMEOUT defaults to '@TIMEOUT', and evaluates to '3000' 2009/02/10 14:01:29.362: Grammar is '' 2009/02/10 14:01:29.363: Grammar Text is '' 2009/02/10 14:01:29.363: Got: '2' 2009/02/10 14:01:29.364: [150] Run Flowchart 2009/02/10 14:01:29.365: Flowchart is 'TICKET' 2009/02/10 14:01:29.366: MM_MENU==> TICKET 2009/02/10 14:01:29.367: [1] START 2009/02/10 14:01:29.368: [7] Run Flowchart 2009/02/10 14:01:29.369: Flowchart is 'MenuSet' 2009/02/10 14:01:29.369: TICKET==> MenuSet 2009/02/10 14:01:29.371: [100] START 2009/02/10 14:01:29.372: [102] Set Global Variable 2009/02/10 14:01:29.374: Setting global variable '@COUNTER' to '3' 2009/02/10 14:01:29.376: [101] FINISH 2009/02/10 14:01:29.377: TICKET<==MenuSet 2009/02/10 14:01:29.378: [3] Play 2009/02/10 14:01:29.379: Script code is 'TICKET01' 2009/02/10 14:01:29.381: Script code 'TICKET01' corresponds to file 'Vox\Eng\Scripts\ticket01.wav' 2009/02/10 14:01:29.382: Playing 'C:\Users\vixen\AppData\Roaming\TeleFlow\Applications\Vox\Eng\Scripts\ticket01.wav' 2009/02/10 14:01:34.130: Interrupted by touch tone 2009/02/10 14:01:34.209: [5] Get TT String 2009/02/10 14:01:34.210: TIMEOUT is '' 2009/02/10 14:01:34.211: Empty TIMEOUT defaults to '@TIMEOUT', and evaluates to '3000' 2009/02/10 14:01:34.212: Maximum TTs is '6' 2009/02/10 14:01:34.212: Allowable TTs is '1234567890' 2009/02/10 14:01:34.214: Termination TTs is '*#' 2009/02/10 14:01:34.215: Setting global variable '@TT_INPUT' to '' 2009/02/10 14:01:39.468: Got: '789674' 2009/02/10 14:01:39.471: Setting global variable '@TT_INPUT' to '789674' 2009/02/10 14:01:39.472: [45] Run Flowchart 2009/02/10 14:01:39.472: Flowchart is 'dbset' 2009/02/10 14:01:39.473: TICKET==> DbSet 2009/02/10 14:01:39.475: [1] START 2009/02/10 14:01:39.475: [3] Set Global Variable 2009/02/10 14:01:39.476: Setting global variable '@DB_COUNTER' to '4' 2009/02/10 14:01:39.477: [2] FINISH 2009/02/10 14:01:39.478: TICKET<==DbSet 2009/02/10 14:01:39.479: [9] SQL Statement 2009/02/10 14:01:39.480: Handle is '1' 2009/02/10 14:01:39.481: Warning time threshold is '' 2009/02/10 14:01:39.482: Empty Warning time threshold defaults to '2000' 2009/02/10 14:01:39.483: <----- BEGIN -----> SELECT prize, issue FROM voucher WHERE number = 789674 <----- END -----> 2009/02/10 14:01:39.498: Error code -1 returned from ODBC driver 2009/02/10 14:01:39.499: SQL Error State: 42S02?Å Native Error Code: FFFFFAE7 ODBC Error: [Microsoft][ODBC dBASE Driver] The Microsoft Office Access database engine could not find the object 'voucher'. Make sure the object exists and that you spell its name and the path name correctly. 2009/02/10 14:01:39.501: Elapsed Time: 0.021 2009/02/10 14:01:39.502: FAILURE 2009/02/10 14:01:39.503: ERROR: Missing next step 2009/02/10 14:01:39.504: FATAL 2009/02/10 14:01:39.504: Attempting to jump to Fatal Error Global Event label: 'APPLICATION_ERROR' 2009/02/10 14:01:39.505: MM_MENU<==TICKET 2009/02/10 14:01:39.505: test<==MM_MENU 2009/02/10 14:01:39.508: Setting system variable '@FATAL' to '' 2009/02/10 14:01:39.508: [8] Label 2009/02/10 14:01:39.510: Label: APPLICATION_ERROR 2009/02/10 14:01:39.512: [17] Run Flowchart 2009/02/10 14:01:39.512: Flowchart is 'Exit' 2009/02/10 14:01:39.513: test==> Exit 2009/02/10 14:01:39.514: [1] START 2009/02/10 14:01:39.515: [8] Global Event 2009/02/10 14:01:39.515: Label is 'EXIT_END' 2009/02/10 14:01:39.517: Setting system variable '@FATAL' to 'EXIT_END' 2009/02/10 14:01:39.517: [11] Global Event 2009/02/10 14:01:39.518: Label is 'EXIT_END' 2009/02/10 14:01:39.518: Setting system variable '@HANGUP' to 'EXIT_END' 2009/02/10 14:01:39.519: [13] Compare 2009/02/10 14:01:39.520: First Value '@HOOK_STATUS' evaluates to 'OFF-HOOK' 2009/02/10 14:01:39.521: Second Value is 'OFF-HOOK' 2009/02/10 14:01:39.522: @HOOK_STATUS = OFF-HOOK? 2009/02/10 14:01:39.523: (string):OFF-HOOK = (string):OFF-HOOK? 2009/02/10 14:01:39.523: TRUE 2009/02/10 14:01:39.524: [3] Play 2009/02/10 14:01:39.525: Script code is 'PROB_TECHNICAL' 2009/02/10 14:01:39.525: ERROR: Script code 'PROB_TECHNICAL' is not in the Voice Script Manager 2009/02/10 14:01:39.526: FATAL 2009/02/10 14:01:39.526: Attempting to jump to Fatal Error Global Event label: 'EXIT_END' 2009/02/10 14:01:39.527: Setting system variable '@FATAL' to '' 2009/02/10 14:01:39.528: [12] Label 2009/02/10 14:01:39.529: Label: EXIT_END 2009/02/10 14:01:39.530: [2] FINISH 2009/02/10 14:01:39.531: test<==Exit 2009/02/10 14:01:39.532: [2] FINISH 2009/02/10 14:01:39.533: End of application. 2009/02/10 14:01:39.533: Hanging up 2009/02/10 14:01:42.535: 2009/02/10 14:01:42.574: All memory released. Exiting... Thanks |
Author: | Chris [ Wed Feb 11, 2009 10:17 am ] |
Post subject: | Re: sql statement |
Here are the standout issues I see: Quote: [5] DB Connect 2009/02/10 14:01:04.049: Parameters is 'DSN=dBASE Files' 2009/02/10 14:01:04.049: ConnectString: DSN=dBASE Files 2009/02/10 14:01:04.124: SQL Error State: HY092 Native Error Code: 56 ODBC Error: [Microsoft][ODBC dBASE Driver]Invalid attribute/option identifier and Quote: 2009/02/10 14:01:39.479: [9] SQL Statement 2009/02/10 14:01:39.480: Handle is '1' 2009/02/10 14:01:39.481: Warning time threshold is '' 2009/02/10 14:01:39.482: Empty Warning time threshold defaults to '2000' 2009/02/10 14:01:39.483: <----- BEGIN -----> SELECT prize, issue FROM voucher WHERE number = 789674 <----- END -----> 2009/02/10 14:01:39.498: Error code -1 returned from ODBC driver 2009/02/10 14:01:39.499: SQL Error State: 42S02?Å Native Error Code: FFFFFAE7 ODBC Error: [Microsoft][ODBC dBASE Driver] The Microsoft Office Access database engine could not find the object 'voucher'. Make sure the object exists and that you spell its name and the path name correctly. There is nothing specifically wrong with the first quoted section, as it does make a connection, but it is a little odd to have a data source named "dBASE Files" that refers to an MS Access database. I would suggest you review the ODBC data source referenced in the "DB Connect" step. Does the "dBASE Files" data source refer to your database? Does it actually reference the database file, directory, server ip, name itself(which of these is required varies based on the database in use)? Does that database contain a table named "voucher"? |
Author: | jazzb2009 [ Thu Feb 12, 2009 9:23 am ] |
Post subject: | Re: sql statement |
in my odbc i have 2 dbase driver files 1 with "microsoft access dBASE driver", other "driver do microsoft access", 1 excel and 1 MS Access Database. i have been actaully trying to connect directly from the odbc administrator to my particular database but i keep failing, tells me connection failed, So i guess thats why it doesnt locate the database to run the statement against. Do you have any suggestions on how i can connect my MS access database to the odbc without using teleflow, cos if i can do this then the proper db connection wil be made as i dont think teleflow is actually connecting to the right database. yes i do have a table in my database called voucher and also the db name i called vouucher as well. Please Advice Thank you. |
Author: | Chris [ Fri Feb 13, 2009 10:19 am ] |
Post subject: | Re: sql statement |
I'm afraid I can't tell you why it's failing. In my MS Access ODBC setup, I don't even see an option to test the connection at all, so I can't necessarily provide you pointers in that regard. I can tell you this is how I would set up the ODBC entry... maybe this will help. (In Windows XP)
* Switch to System DSN tab * Click "Add..." * Select "Microsoft Access Driver (*.mdb)" and click "Finish" * Make the "Data Source Name:" something meaningful that relates to your database and/or project/application. * Click "Select..." * Locate the database file on disk and select it. * Ensure that your DB Connect step in TeleFlow uses the data source name you specified in the ODBC Data Source Administrator. If you can't make connections successfully at that point, you might want to look to Microsoft help/support resources to get the data source properly defined before attempting to use it in TeleFlow. A final point: MS Access may work fine for testing, but we recommend against using it in production. We tried in the past, and there are some problems that you can only create workarounds for, and even then, they can occassionally stall your lines. |
Author: | jazzb2009 [ Tue Feb 24, 2009 11:33 am ] |
Post subject: | Re: sql statement |
Hi there, Thanks for your help as the info you provided me was of uttermost assistance, I finally got the service working as the major problem i had, was my odbc connector was not pointing directly to my Database. with i solved using mysql odbc connector 3.51 version as the 5.1 version still experiences parameter bugs. Please how do i connect the Teleflow application to a telephone number, so it does the functions of an ivr. Thank you. |
Author: | jazzb2009 [ Wed Feb 25, 2009 9:11 am ] |
Post subject: | Re: sql statement |
Hi, I noticed in the deploy teleflow app in the manual it has something to do with teleflow line list, when i try to open my saved application which was saved in application folder, i do not find it only the AnswerTest seems to be visible. My saved application works fine with the simulator but when i click into the other folders, like the tam, vox and log they are all empty, how is that. because when i open the AnswerTest file, i see the folders in there are populated. Please also remember i duplicated steps from one of the demonstartions on teleflow and then just saved it in the application folder as "NewApplication". I hope you do understand my gibberish as i feel as though its all over the place. Please assist. |
Author: | Chris [ Wed Feb 25, 2009 10:24 am ] |
Post subject: | Re: sql statement |
If you follow the help chapters and topics relating to configuring and deploying, this will get you well on your way to your goal. Specifically, start with the following chapters and topics: - 3 - Configure TeleFlow Server
* TeleFlow Config * TeleFlow Register (NOTE: This is needed only if you are licensing TeleFlow, which is not required for initial setup. You can run in demo mode if you skip this step.) As for why you can't locate your TeleFlow Application on disk, I'm not sure. I suggest the following:
* Click "File", then "Open Application Folder in Explorer". This should take you to the correct path and file for your application. The topics I suggest don't address hardware, other than to tell you how to configure TeleFlow to run the hardware you are using. What telephony hardware are you intending to run your application(s) on? |
Author: | jazzb2009 [ Wed Feb 25, 2009 5:55 pm ] |
Post subject: | Re: sql statement |
Hello, I was able to locate the path of application on my hard drive by opening it with windows explorer, thanx. so i have been able to build the teleflow line list. When i open the TFconfig, it already selects the dialogic, i added the app from the line list and selected start tf server automatic mode and click ok, i get a message saying i have to restart TFserver from the service control manager, which i have done. As i read on it says to configure the TFserver i have to have hardware installed. BUt as i opened the service control to restart TFserver i noticed a telephony service running. Please does this mean i probable have voice card insalled or i definitely have to buy and install a proper voice/telephony card? Please explain Thanx. |
Author: | Chris [ Thu Feb 26, 2009 10:13 am ] |
Post subject: | Re: sql statement |
If the service you are referring to is named "Telephony", this is a service for TAPI, and won't allow you to run anything live(I.e. on a telephone line) with TeleFlow. So yes, you will need to buy and install a proper voice/telephony card in order to connect a phone line. If you can describe your anticipated needs (in terms of simultaneous calls, and the types of application(s) you intend to run), I can provide some advice in terms of what cards might work for you. |
Author: | jazzb2009 [ Fri Feb 27, 2009 9:30 am ] |
Post subject: | Re: sql statement |
Looking to run an app. where x amount of inbound calls come in to query a database. No intended transferred calls but would like to make provision for the transfer call option just in case the need arises. Also looking to run the setup from a laptop, is this possible using a voice modem or what would you recommend? Please Advise, Thanx |
Author: | Chris [ Mon Mar 02, 2009 10:24 am ] |
Post subject: | Re: sql statement |
The "x" calls is important to the determination of the appropriate card. If you expect to only ever have 1 or 2 simultaneous calls at one time, this is much different than 10-20 simultaneous calls. So, your expected functionality is all "basic IVR"? (I.e. Answer the phone, accept touch-tone inputs, get/put data from/in the database, possibly do call transfers) TeleFlow doesn't work with modems, you will need a telephony card. TeleFlow has support for Dialogic, NMS, and Ai-Logix cards, although active applications (those that answer calls) are primarily run on Dialogic or NMS hardware. Those cards won't fit in a laptop, and in fact, you even have to be careful about a server-grade computer you intend to put a telephony card in, because many of these haven't the room in the case for some of the larger (full-length) cards. |
Author: | jazzb2009 [ Mon Mar 02, 2009 11:46 am ] |
Post subject: | Re: sql statement |
I expect that there could be as many as 20 simultaneous call coming in at the same time and it a basci ivr app. what u think wil be the best board for this? When choosing a server type computer, what exact specifications do u recommend be built, that will function with teleflow? Thanks |
Author: | Chris [ Mon Mar 09, 2009 3:13 pm ] |
Post subject: | Re: sql statement |
For 20 simultaneous calls, your best bet would be to get a PRI (ISDN), which is good for up to 23. I would recommend an NMS CG 6060 card. If you have a reasonable expectation that you will get to a higher number of calls relatively quickly, you might want to consider getting a dual card (I.e. One capable of hosting 2 ISDN spans, for a total of 46 channels/simultaneous calls) Just so you know: When it comes to transfers on ISDN, you have to have some channels dedicated to making outbound calls. For assistance with pricing/purchasing a card, please contact sales@engenic.com. As for the server, the following link should provide the details you are looking for: TeleFlow System Requirements |
Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |