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

[Wes Baehr]

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 < <mailto:limleechin2005 at gmail.com>  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
<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 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20061115/2c65e986/attachment.htm