[asterisk-users] Re: Is asterisk able to integrate with MS SQL

[Tony Mountifield]

In article <9bd3e43a0611141600i4cd6285cyda966079f88c3bb5 at mail.gmail.com>,
Sharon Lim <limleechin2005 at gmail.com> 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: tony at softins.co.uk - http://www.softins.co.uk
Play: tony at mountifield.org - http://tony.mountifield.org