jlperezdiaz Report post Posted 10/05/2006 05:33 AM Scenario: 1) Simple script try to do a query (very simple - just for the testing) 2) Created odbc on windows. Tested and worked fine with Mssql and Mysql from ODBC forms in windows. 3) It faill from voiceguide with both (Mssql and Mysql) 4) With ethereal I´ve seen there is connection with the database in both Mssql and Mysql but it fails when it tries de query 5) Config of the properties on voice of the Database Control (I´ve changed many options but no difference) CSDU3 ODBC;DSN=CSDU3;UID=abcde;PWD=xyzdef;srv=192.168.25.153 select * from pin; 6) These are the traces 072356.17 4 matching path was found 072356.52 4 fn RunModule start [Database Query,[saldo_Cliente],3,,] 072356.55 4 timer clear 072356.58 4 state [saldo_Cliente] DB Query 072356.61 4 db ODBC mode used 072356.67 4 ERROR 6.0.3160 OpenDatabase [76:Path not found] 072356.69 4 path {76} not found 072356.72 4 path {Path not found} not found 072356.75 4 next module is [HangupCall] (idx=2) 072356.78 4 fn RunModule start [Hangup the Call,[HangupCall],2,,] 072356.81 4 timer clear 7) I´ve tried with Mysql with the latest odbc and the previous one. But as I´ve said it fails withe SQL Server too. 8) We are working with a Windows 2000 server / with all the upgrades,etc... Note: we have other voiceguide system working with 9 months older release working with no problem. This is related with the latest release. Any clue about what it could be the reason? I´m lost. Many thanks in advance. José Luis Share this post Link to post
SupportTeam Report post Posted 10/05/2006 07:11 AM Can you post the script you are using? Have you tried leaving the database name blank and just using the Connect string? Another option is to try the Database query from a VBScript - there are some samples on how to do this in the Help file. Share this post Link to post
jlperezdiaz Report post Posted 10/05/2006 07:52 AM 1) Script: Basically it´s just for testing the database connection. Version=5.0 DefaultModuleDisplayHeight= StartModule=MVNO_IVR RunAtHangup= StartWithoutAnswer=1 CtmAsiName= [MVNO_IVR] Type=Evaluate DispSize=69 Txt=Evaluate the Result Variable specified, and select the path which matches the current value of the Result Variable Expression=$RV[DNIS] ExprNewRV= ExprStoreRV=0 ExprStoreInGlobalRV=0 on {800007599} goto [saldo_Cliente] on {901007599} goto [HangupCall] on {902007599} goto [saldo_Cliente] on {true} goto [HangupCall] on {false} goto [HangupCall] Position=460,72 [HangupCall] Type=Hangup the Call DispSize=69 Txt=Hangup the call. Position=453,534 [saldo_Cliente] 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=CSDU3 DbUser= DbConnectString=ODBC;DSN=CSDU3;UID=raquel;PWD=rakel;srv=192.168.25.153 DbSql=select * from pin; on {success} goto [Transfer_Call] on {fail} goto [HangupCall] Position=630,214 [say Numbers 188] Type=Say Numbers DispSize=69 Txt=Say the number, amount, date or the digits. See the list o options to see how the number supplied can be interpreted and spoken out... Replay=2,5 SayNbrType= Position=640,361 [Transfer_Call] Type=Transfer Call DispSize=69 Txt=Transfer call to the selected extension. strXferDestExt=918290100 iXferType=31 sXfer2ndLegLinesListFile= sXferPlayWhileDialing= sXferAnnounceMsg= Position=912,248 2) If we leave the database name in blank does the same. It appears the same message on the logs 094840.67 4 next module is [saldo_Cliente] (idx=8) 094840.67 4 matching path was found 094840.69 4 fn RunModule start [Database Query,[saldo_Cliente],8,,] 094840.69 4 timer clear 094840.69 4 state [saldo_Cliente] DB Query 094840.70 4 db ODBC mode used 094840.73 4 ERROR 6.0.3160 OpenDatabase [76:Path not found] 094840.73 4 path {76} not found 094840.75 4 path {Path not found} not found 094840.75 4 next module is [HangupCall] (idx=7) 094840.75 4 fn RunModule start [Hangup the Call,[HangupCall],7,,] 094840.77 4 timer clear 094840.77 4 state [HangupCall] Hangup Call 094840.77 4 HangupCall start (Hangup Module) 3) I will try, although I don´t have a big experience with VBscript Share this post Link to post
jlperezdiaz Report post Posted 10/05/2006 09:29 PM We are still having problems connecting with odbc. a) we are using the software (originally downloaded as trial from your web) 232249.41 2 db ODBC mode used 232249.45 2 ERROR 6.0.3160 OpenDatabase [76:Path not found] 232249.45 2 path {76} not found DO WE NEED OTHER VOICEGUIDE VERSION TO INSTALL? We have not installed anything else the operative system (win2000 server) + all the updates for windows web page + net 2.0 framework + all dialogic 5.1 + dialogic 5.1 service pack1. DO WE NEED TO INSTALL ANY OTHER SW OR LIBRARIES,ETC...? c) We have tested through clients the odbc connectivity is right (with sql server and with mysql), but it fails with voiceguide from the scripts. It´s curious with ethereal in the same server we can see it´s connecting to the database right, but it doesn´t execute the query. ANY INCOMPATIBILITY WE COULD TRY TO FIND? We have begin using same config in other systems with other apps are working with your previous releases. OUR FEELING IS PERHAPS WE HAVE NOT INSTALLED SOMETHING IS REQUIRED, BUT WE ARE LOST. WE WOULD APPRECIATE YOUR HELP. BEST REGARDS Share this post Link to post