I have an IVR for employees to enter certain information, like employee number and such and then I pass that to a simple agi/php script that build the query string and uses freetds. It took me a while to get it working and reproduce it on several systems, but I am rather new to Linux in general.
<br><br><div><span class="gmail_quote">On 11/15/06, <b class="gmail_sendername">Tony Mountifield</b> <<a href="mailto:tony@softins.clara.co.uk">tony@softins.clara.co.uk</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
In article <<a href="mailto:9bd3e43a0611141600i4cd6285cyda966079f88c3bb5@mail.gmail.com">9bd3e43a0611141600i4cd6285cyda966079f88c3bb5@mail.gmail.com</a>>,<br>Sharon Lim <<a href="mailto:limleechin2005@gmail.com">
limleechin2005@gmail.com</a>> wrote:<br>> -=-=-=-=-=-<br>> -=-=-=-=-=-<br>><br>> Thanks, will do more research on that part. By the way, Im trying to do IVR<br>> where caller enter the pin the retrieve some information out of the MS SQL.
<br>> I am wondering, what is the constraints or how to go about it. As per said<br>> MS SQL is about CDR. Now like i want to match and retrieve data out of the<br>> DB through IVR. Any guidance?<br><br>I don't think there is any direct access to MS SQL via FreeTDS from the
<br>dialplan, but there are ODBC functions you could use. See this page:<br><br><a href="http://www.voip-info.org/wiki/view/Asterisk+app_dbodbc">http://www.voip-info.org/wiki/view/Asterisk+app_dbodbc</a><br><br>Alternatively, implement your IVR using AGI or the ExternalIVR application
<br>and then you can do what you like with the database.<br><br>See <a href="http://www.voip-info.org/wiki-Asterisk+AGI">http://www.voip-info.org/wiki-Asterisk+AGI</a><br>and <a href="http://www.voip-info.org/wiki-Asterisk+cmd+ExternalIVR">
http://www.voip-info.org/wiki-Asterisk+cmd+ExternalIVR</a><br><br>Cheers<br>Tony<br>--<br>Tony Mountifield<br>Work: <a href="mailto:tony@softins.co.uk">tony@softins.co.uk</a> - <a href="http://www.softins.co.uk">http://www.softins.co.uk
</a><br>Play: <a href="mailto:tony@mountifield.org">tony@mountifield.org</a> - <a href="http://tony.mountifield.org">http://tony.mountifield.org</a><br>_______________________________________________<br>--Bandwidth and Colocation provided by
<a href="http://Easynews.com">Easynews.com</a> --<br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users
</a><br></blockquote></div><br><br clear="all"><br>-- <br>Bruce<br>Nortex Networks