Calling Sql Server Stored Procedures

[arba7ak]

Hello,

 

I have Voice Guide for TAPI running on Windows XP. I have an 2012 R2 SQL Server Database.

 

I have tried to use SQL Statements with the database module and it succeed for simple queries however when I use some SQL Server functions like CONVERT or CASE in the statement it fails always although I tried it on the server directly and it succeed.

 

Also I tried to call SQL Server Stored Procedures using this text

 

exec sp_name

 

It also fails.

 

Kindly let me know how to solve the two problems above.

 

Regards,

Ehab Zaky

[SupportTeam]

In VoiceGuide v5 you may need to use the 'Run VBScript' module to make the CONVERT / CASE etc. SQL queries

You would need to connect to the database from within a VBScript and run the command.

 

In VoiceGuide v7 you should be able to run the CONVERT / CASE / EXEC etc. commands from the Database Query module.

 

if you are using a Dialogic card on your system then we would recommend using VoiceGuide v7.