I went with FreeTDS to accomplish this at one point and it worked great
in Dev (no call volume). It seemed to work better than ODBC since it is
speaking with M$ SQL natively rather than through an additional layer
although there is much debate about this on the net.
We were doing a bunch of local perl agi stuff too and the box started
crawling when we went live so we just went with FastAGI and a service
running on a Windows box to listen and process the FastAGI stuff, query
the M$ DB and return variables or do inserts. This approach turned out
to be lightning fast. Multiple FastAGI services can run on the same box
as long as they use different port numbers and are called by IP and port
number in your dialplan.
For your app you could use many of the standard channel variables that
are passed in FastAGI but not used (such as RDNIS in my case) to send
the data you want to interact with your DB. I have also read that in
later versions of Asterisk, you can pass other variables but I have not
really researched that since I do not need it (yet).
Also, if your app is never really going to see volume, then FreeTDS
along with local AGIs should work just fine but I would still suggest
what worked for me above. Maybe others have a better way of doing it?
I would love to hear from them.
Thanks,
Steve Totaro
Sharon Lim wrote:
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]
<mailto:[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]>
[mailto:[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]
<mailto:[EMAIL PROTECTED]>> wrote:
In article <
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>,
Sharon Lim < [EMAIL PROTECTED]
<mailto:[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] <mailto:[EMAIL PROTECTED]> -
http://www.softins.co.uk <http://www.softins.co.uk>
Play: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -
http://tony.mountifield.org
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com
<http://Easynews.com> --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
<http://lists.digium.com/mailman/listinfo/asterisk-users>
--
Bruce
Nortex Networks
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com
<http://Easynews.com> --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
<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
_______________________________________________
--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
