Yes, I have done it. I am able to connect using odbc. Now able to write to ms sql and also retrieve in db. Now my next steps is I need to write an app which takes a phone call, asks for the user to input a number and then queries a MS SQL db and reads the results a row at a time back to the caller.
anyway got example or how to go about this? I am really refresh in programming. thanks in advance! On 11/15/06, Wes Baehr <[EMAIL PROTECTED]> wrote:
Func_odbc (which is new in 1.4) was backported to 1.2. See http://www.asterisk.org/func_odbc While it only will return one row (there are patches to make it return multiple rows), it's very useful for our purposes. You set up the function in func_odbc.conf, call it with ${ODBC_FunctionName(arg1,arg2,…)} and it executes and returns the specified data. -- Wes Baehr ------------------------------ *From:* [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *On Behalf Of *Bruce Reeves *Sent:* Wednesday, November 15, 2006 7:56 AM *To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] Re: Is asterisk able to integrate with MS SQL 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. On 11/15/06, *Tony Mountifield* <[EMAIL PROTECTED]> wrote: 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 -- Bruce Nortex Networks _______________________________________________ --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
-- Regards, Sharon Lim *Good memories are to be folded neatly and tucked away into the back pocket *
_______________________________________________ --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
