In article <[EMAIL PROTECTED]>, Sharon Lim <[EMAIL PROTECTED]> wrote: > -=-=-=-=-=- > -=-=-=-=-=- > > Thanks, will do more research on that part. By the way, Im trying to do IVR > where caller enter the pin the retrieve some information out of the MS SQL. > I am wondering, what is the constraints or how to go about it. As per said > MS SQL is about CDR. Now like i want to match and retrieve data out of the > DB through IVR. Any guidance?
I don't think there is any direct access to MS SQL via FreeTDS from the dialplan, but there are ODBC functions you could use. See this page: http://www.voip-info.org/wiki/view/Asterisk+app_dbodbc Alternatively, implement your IVR using AGI or the ExternalIVR application and then you can do what you like with the database. See http://www.voip-info.org/wiki-Asterisk+AGI and http://www.voip-info.org/wiki-Asterisk+cmd+ExternalIVR Cheers Tony -- Tony Mountifield Work: [EMAIL PROTECTED] - http://www.softins.co.uk Play: [EMAIL PROTECTED] - http://tony.mountifield.org _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
