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

2006-11-23 Thread Sharon Lim
: [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

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

2006-11-23 Thread Steve Totaro
] 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

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

2006-11-15 Thread Tony Mountifield
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

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

2006-11-15 Thread Bruce Reeves
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.

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

2006-11-15 Thread Wes Baehr
-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

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

2006-11-14 Thread Stéphane LASSERRE
You need to install unixodbc also -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Tony Mountifield Envoyé : mardi 14 novembre 2006 11:22 À : asterisk-users@lists.digium.com Objet : [asterisk-users] Re: Is asterisk able to integrate with MS SQL

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

2006-11-14 Thread Tony Mountifield
In article [EMAIL PROTECTED], Sharon Lim [EMAIL PROTECTED] wrote: Hi there, I am looking around, is there anyone did any integration asterisk talk to / connect to MS SQL? Look for the package FreeTDS and install it. Then build Asterisk and it will include the TDS driver that can log CDRs

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

2006-11-14 Thread Vicky
oops sorry i thought its my sql didnt notice it's MS SQL :D On 14/11/06, Tony Mountifield [EMAIL PROTECTED] wrote: In article [EMAIL PROTECTED],Sharon Lim [EMAIL PROTECTED] wrote: Hi there, I am looking around, is there anyone did any integration asterisk talk to / connect to MS SQL?Look for the

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

2006-11-14 Thread Tony Mountifield
In article [EMAIL PROTECTED], Vicky [EMAIL PROTECTED] wrote: Yes asterisk can do that . If you mena for call records then see http://www.voip-info.org/wiki-Asterisk+cdr+mysql Also see http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL The OP was asking about MS SQL (i.e. Microsoft SQL

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

2006-11-14 Thread Sharon Lim
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