Connecting to database through TCL

Version 1
    This document was generated from CDN thread

    Created by: Sara Afghan on 25-09-2012 02:55:07 AM
    Hi
    I am wondering if we can connect directly to database using TCL IVR as is done in standard TCL/TK:
    http://stackoverflow.com/questions/8464052/connecting-to-microsoft-sql-server-using-tcl 
    If there is no possiblity of extending TCL IVR in that case, which way do you propose for connecting a tcl script to MS SQL database, I know it can be done through cisco secure ACS and also voice XML. My request to connect to a database stems from the following scenario:
    I need to access some predefined holidays and special days that reside in a MS SQL database and are subject to change periodically. I want to have the ability to read such database and  play the corresponding voice menu.
     

    Subject: RE: Connecting to database through TCL
    Replied by: Yaw-Ming Chen on 25-09-2012 12:36:43 PM
    Sara Afghan:
    Hi
    I am wondering if we can connect directly to database using TCL IVR as is done in standard TCL/TK:
    http://stackoverflow.com/questions/8464052/connecting-to-microsoft-sql-server-using-tcl 
    If there is no possiblity of extending TCL IVR in that case, which way do you propose for connecting a tcl script to MS SQL database, I know it can be done through cisco secure ACS and also voice XML. My request to connect to a database stems from the following scenario:
    I need to access some predefined holidays and special days that reside in a MS SQL database and are subject to change periodically. I want to have the ability to read such database and  play the corresponding voice menu.
     

     
    Don't know what exactly you like to with database .Tcl IVR API can communicate with Cisco ACS. Please refer to those aaa xxxxx commands in programming guide.
     
    In term of playing different message you can ustilze stand tcl command to determine date of year, time of date to play different voice prompt. You can make those prompt configurable under application "param"

    Subject: RE: Connecting to database through TCL
    Replied by: Chris Manuh on 28-09-2012 09:38:58 AM
    You could write a web services that interacts with your database and from your TCL script, use the httpios package to connect to your webservice to send and receive data.