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.<br><br>anyway got example or how to go about this? I am really refresh in programming. thanks in advance!<br><br><div><span class="gmail_quote">On 11/15/06, <b class="gmail_sendername">
Wes Baehr</b> <<a href="mailto:wbaehr@abilitybusiness.com">wbaehr@abilitybusiness.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="blue" lang="EN-US">
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Func_odbc (which is new in 1.4) was
backported to 1.2. See <a href="http://www.asterisk.org/func_odbc" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.asterisk.org/func_odbc</a></span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">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.</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">--</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Wes
Baehr</span></font><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"></span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<div style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color blue; border-width: medium medium medium 1.5pt; padding: 0in 0in 0in 4pt;">
<div>
<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">
<a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">asterisk-users-bounces@lists.digium.com</a>
[mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">asterisk-users-bounces@lists.digium.com</a>] <b><span style="font-weight: bold;">On Behalf Of
</span></b>Bruce Reeves<br>
<b><span style="font-weight: bold;">Sent:</span></b> Wednesday, November 15, 2006
7:56 AM<br>
<b><span style="font-weight: bold;">To:</span></b> Asterisk
Users Mailing List - Non-Commercial Discussion<br>
<b><span style="font-weight: bold;">Subject:</span></b> Re: [asterisk-users] Re:
Is asterisk able to integrate with MS SQL</span></font></p>
</div><div><span class="e" id="q_10eebf27ce1cebca_1">
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p style="margin-bottom: 12pt;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">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. </span></font></p>
<div>
<p><span><font face="Times New Roman" size="3"><span style="font-size: 12pt;">On 11/15/06, <b><span style="font-weight: bold;">Tony
Mountifield</span></b> <<a href="mailto:tony@softins.clara.co.uk" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">tony@softins.clara.co.uk</a>>
wrote:</span></font></span></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">In article <<a href="mailto:9bd3e43a0611141600i4cd6285cyda966079f88c3bb5@mail.gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
9bd3e43a0611141600i4cd6285cyda966079f88c3bb5@mail.gmail.com</a>>,<br>
Sharon Lim <<a href="mailto:limleechin2005@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
limleechin2005@gmail.com</a>> wrote:<br>
> -=-=-=-=-=-<br>
> -=-=-=-=-=-<br>
><br>
> Thanks, will do more research on that part. By the way, Im trying to do
IVR<br>
> where caller enter the pin the retrieve some information out of the MS
SQL. <br>
> I am wondering, what is the constraints or how to go about it. As per said<br>
> MS SQL is about CDR. Now like i want to match and retrieve data out of the<br>
> DB through IVR. Any guidance?<br>
<br>
I don't think there is any direct access to MS SQL via FreeTDS from the <br>
dialplan, but there are ODBC functions you could use. See this page:<br>
<br>
<a href="http://www.voip-info.org/wiki/view/Asterisk+app_dbodbc" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.voip-info.org/wiki/view/Asterisk+app_dbodbc</a><br>
<br>
Alternatively, implement your IVR using AGI or the ExternalIVR application <br>
and then you can do what you like with the database.<br>
<br>
See <a href="http://www.voip-info.org/wiki-Asterisk+AGI" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.voip-info.org/wiki-Asterisk+AGI</a><br>
and <a href="http://www.voip-info.org/wiki-Asterisk+cmd+ExternalIVR" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.voip-info.org/wiki-Asterisk+cmd+ExternalIVR</a><br>
<br>
Cheers<br>
Tony<br>
--<br>
Tony Mountifield<br>
Work: <a href="mailto:tony@softins.co.uk" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">tony@softins.co.uk</a> - <a href="http://www.softins.co.uk" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.softins.co.uk </a><br>
Play: <a href="mailto:tony@mountifield.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">tony@mountifield.org</a> - <a href="http://tony.mountifield.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://tony.mountifield.org</a><br>
_______________________________________________<br>
--Bandwidth and Colocation provided by <a href="http://Easynews.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Easynews.com</a>
--<br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://lists.digium.com/mailman/listinfo/asterisk-users
</a></span></font></p>
</div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><br>
<br clear="all">
<br>
-- <br>
Bruce<br>
Nortex Networks </span></font></p>
</span></div></div>
</div>
</div>
<br>_______________________________________________<br>--Bandwidth and Colocation provided by <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://Easynews.com" target="_blank">Easynews.com</a> --<br><br>
asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users
</a><br><br><br></blockquote></div><br><br clear="all"><br>-- <br>Regards, <br>Sharon Lim <br><br>*Good memories are to be folded neatly and tucked away into the back pocket *