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

[Sharon Lim]

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 <wbaehr at abilitybusiness.com> 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:* asterisk-users-bounces at lists.digium.com [mailto:
> asterisk-users-bounces at lists.digium.com] *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* <tony at softins.clara.co.uk> wrote:
>
> 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
> _______________________________________________
> --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
*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20061123/b1a490ed/attachment.htm