Db Query Timeout

[tfreame]

I have VoiceGuide 5.2.3018 successfully querying an MSSQL server but when I test for a timeout (to allow for SQL server/network downtime) the DB query module does not timeout at 5 secs as I'm expecting.

 

I'm simulating a server unavailable situation by disconnecting the network connection from the VoiceGuide PC.

 

The script runs the DB query module and stops for 20 seconds before a Microsoft SQL Server Login failure box appears. I have to OK that and then cancel the login before VoiceGuide continues. I'm using the standard SQL Server driver that comes with Win 2000.

 

I have a path of "on {timeout 5} goto [CheckValid]" set in the query module. The connect string is just "ODBC;".

 

I can't find any timeout settings in ODBC and nothing in any help file or microsoft web site. I hope you can help.

 

Thanks

[tfreame]

Did I ask a stupid question so you are ignoring it?? If you don't intend to respond please indicate that and I'll go somewhere else.

 

I still can't get the DB Query module to timeout even when the SQL login is OK but the query takes longer than 5 seconds.

 

I can't see what I'm doing wrong.

[SupportTeam]

For database connections any timeouts on queries should be specified within the ODBC driver itself (or the ODBC connect string). Timeouts for database queries at his stage cannot be specified from within the VoiceGuide's DB Query module.

 

You can use timeout paths if the query is made from within a VBScript module - for examples of how to perform database queries from within VBScript module please see: http://www.voiceguide.com/vghelp/html/modVbs.htm