elogypeter Report post Posted 02/17/2004 10:06 PM Hello, I am using VoiceGuide 4.7 and have problems writing/updating databases via ODBC I am using MySQL via MyODBC on a WIN2k server All read actions (like SELECT from ..) are OK but for some reason I cannot write or update records via ODBC I always get "ERROR: DB Execute: 3001,Invalid argument." in the event log. Please help, I also tried a MS Access ODBC dbase but same problem. Many thanks, Peter This is my test vgs script: Version=4.5 DisplayType= StartModule=Database Query 32 RunAtHangup= StartWithoutAnswer=0 CtmAsiName= [Database Query 32] Type=Database Query DispSize=69 Txt=Search the database for data. You can then use the returned results later in your script (see Result Variables), eg: in the Say Number module or as parameters to the program calles in a Run Program module. DbDatabase=sql_imode DbUser= DbConnectString=ODBC;DRIVER={MySQL ODBC 3.51 Driver};server=localhost;database=sql_imode;user=root;password=;port=3306 DbSql=UPDATE sessies SET tijd_call='nu' WHERE ID=28962 Position=21,33 this is the eventlog: 43395 6 tapie linedevstate 2048 0 0 43395 6 tapie callstate OFFERING 0 4 43395 6 Answer the call 43405 6 lineAnswer(65727) => 66105 43405 6 tapie callinfo CALLEDID 43405 6 tapie callinfo ORIGIN 43415 6 tapie ring 0 43936 6 tapie callstate CONNECTED 65727,1,0 43946 6 WorkingModeTAPI= 43946 6 WorkingModeScript= 43966 6 tapi Reply 66105 0 43976 6 tapie callinfo MONITORMODES 43976 6 TimeoutClear 43976 6 [Database Query 32] DB Query 43986 6 ODBC mode used 44076 6 About to execute Action Query 44086 6 ERROR: DB Execute: 3001,Invalid argument. 44086 6 Hanging up call... 44096 6 TimeoutSet 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP 44096 6 PlaySoundStop ok 44106 6 HangupCall lineDrop(6, 0) =>66329 (66329) 44106 6 fnHangupCall end 44116 6 tapi Reply 66243 LINEERR_OPERATIONFAILED [80000048] 45979 6 tapie linedevstate 2048 0 0 45989 6 tapie callstate IDLE 0 0 45989 6 WorkingMode@Idle= 45989 6 TimeoutClear 45999 6 TimeoutSet 1 EV_TIMEOUT_TIMETOREINITLINE 46009 6 tapi Reply 66329 0 46981 6 Timer fired 6, 9008 46981 6 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE 46991 6 Initialise telephony (due to IDLE) 46991 6 tapic lineDeallocateCall(MainCall:65727) 0 47061 6 Waiting for a call... 47071 6 TimeoutSet 5 EV_TIMOUT_ATERIDLE_ALLOWOUT 52078 6 Timer fired 6, 9025 Share this post Link to post
SupportTeam Report post Posted 02/17/2004 10:29 PM v4.7 is a pretty old version now (3 years?) So it's a bit hard to comment on issues which you encounter with that version. I'd recommend updating to v5.1 – there are many sites running a MySQL/MyODBC combination using VG v5.x with no problems. Share this post Link to post
