<!DOCTYPE html PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'>
<html><head><meta http-equiv="Content-Type" content="text/html;charset=utf-8">
<style>BODY{font:10pt Tahoma, Verdana, sans-serif}</style></head><body>
<DIV>The DSN is only for freeswitch internal data, and some of the apps. There is no native options in freeswitch to use a database for users, call routing etc...</DIV>
<DIV> </DIV>
<DIV>Setting up a DSN will work just fine to move the internal SQLite data into MSSQL, but that really won't buy you much for the other applications.</DIV>
<DIV> </DIV>
<DIV>If you want to replace config (Directlry, Dialplan, other config...) you have a few options.</DIV>
<DIV> </DIV>
<DIV>Use mod_xml_curl, and do it real time w/ HTTP and an external app.</DIV>
<DIV> </DIV>
<DIV>Use one of the scriptiong languages that allow you to configure a script to run to generate the XML on the fly.</DIV>
<DIV> </DIV>
<DIV>Or on winodws a very easy method (if you can code in C# or VB) would be to write a plugin that can be loaded by MOD_MANAGED to convert stuff in your database to real-time configuraton. (in C# this could be done in as few as 10 lines of code) This would allow you to connect to any DB for anything.</DIV>
<DIV> </DIV>
<DIV>Since two of the things that are very easy in C#, reading databases, and generating XML, and the ease of converting a database record to XML in a single line of code (LINQ syntax) this is a very easy option to get started.</DIV>
<DIV> </DIV>
<DIV>--Dave</DIV><BR>
<BLOCKQUOTE style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<HR>
<B>From:</B> Andre Demattia [mailto:andretodd@verizon.net]<BR><B>To:</B> FreeSWITCH Users Help [mailto:freeswitch-users@lists.freeswitch.org]<BR><B>Sent:</B> Tue, 26 Mar 2013 11:13:24 -0700<BR><B>Subject:</B> Re: [Freeswitch-users] Freeswitch + MSSQL<BR><BR>
<DIV>
<DIV style="FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt">I'm using windows. Will that still work?<BR>I also want to use the manage lib in c# but I can't find anything worth wile for examples.<BR>I see a post that has <param name= "core-dbtype" value ="mdsql"><BR>Not sure the steps for setting it up and where the SQL goes.</DIV></DIV>
<DIV>
<HR>
<SPAN style="FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt; FONT-WEIGHT: bold">From: </SPAN><SPAN style="FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt"><A href="mailto:krice@freeswitch.org">Ken Rice</A></SPAN><BR><SPAN style="FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt; FONT-WEIGHT: bold">Sent: </SPAN><SPAN style="FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt">3/26/2013 2:00 PM</SPAN><BR><SPAN style="FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt; FONT-WEIGHT: bold">To: </SPAN><SPAN style="FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt"><A href="mailto:freeswitch-users@lists.freeswitch.org">FreeSWITCH Users Help</A></SPAN><BR><SPAN style="FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt; FONT-WEIGHT: bold">Subject: </SPAN><SPAN style="FONT-FAMILY: Calibri,sans-serif; FONT-SIZE: 11pt">Re: [Freeswitch-users] Freeswitch + MSSQL</SPAN><BR><BR></DIV><FONT face="Monaco, Courier New"><SPAN style="FONT-SIZE: 11pt">The configurations in the books should show ODBC configurations, the UnixODBC configuration is just that the ODBC configuration for *nix platforms, once you have your DSN setup for MSSQL you just tell FS ODBC://DSN:user:pass where it asks for DSNs in the config. For users/routing you’ll have you either write something to handle that or use one of the existing XML via http formats... See the wiki for how mod_xml_curl works<BR><BR><BR>On 3/26/13 12:54 PM, "Andre Demattia" <<A href="https://mail.tritonwest.net:442/webmail/andretodd@verizon.net">andretodd@verizon.net</A>> wrote:<BR><BR></SPAN></FONT>
<BLOCKQUOTE><SPAN style="FONT-SIZE: 11pt"><FONT face="Calibri, Verdana, Helvetica, Arial">User databases, call routing etc. I am not sure what the steps are. The book I have only shows Linux configuration not odbc to mssql.<BR></FONT><FONT face="Monaco, Courier New">
<HR align=center SIZE=3 width="100%">
</FONT><FONT face="Calibri, Verdana, Helvetica, Arial"><B>From: </B>Dave R. Kompel <<A href="mailto:drk@drkngs.net">mailto:drk@drkngs.net</A>> <BR><B>Sent: </B>3/26/2013 1:39 PM<BR><B>To: </B>FreeSWITCH Users Help <<A href="mailto:freeswitch-users@lists.freeswitch.org">mailto:freeswitch-users@lists.freeswitch.org</A>> <BR><B>Subject: </B>Re: [Freeswitch-users] Freeswitch + MSSQL<BR></FONT><FONT face="Monaco, Courier New"><BR>Connect it how? Use it for the internal database, or do other things with it, such as User databases, call routing etc...?<BR> <BR>--Dave<BR><BR></FONT></SPAN>
<BLOCKQUOTE><SPAN style="FONT-SIZE: 11pt"><FONT face="Monaco, Courier New">
<HR align=center SIZE=3 width="100%">
<B>From:</B> Andre Demattia [<A href="mailto:andretodd@verizon.net">mailto:andretodd@verizon.net</A>]<BR><B>To:</B> <A href="https://mail.tritonwest.net:442/webmail/freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</A> [<A href="mailto:freeswitch-users@lists.freeswitch.org">mailto:freeswitch-users@lists.freeswitch.org</A>]<BR><B>Sent:</B> Tue, 26 Mar 2013 08:49:25 -0700<BR><B>Subject:</B> Re: [Freeswitch-users] Freeswitch + MSSQL<BR><BR><BR><BR>HI, I'm new to Freeswitch and need to know how to connect my Windows Freeswitch to MSSQL.<BR>Can you share your example and step by step instructions ?<BR>I assume I need a Mod?<BR>Thanks<BR></FONT></SPAN></BLOCKQUOTE><SPAN style="FONT-SIZE: 11pt"><FONT face="Monaco, Courier New"><BR> <BR><BR>
<HR align=center SIZE=3 width="95%">
</FONT></SPAN><FONT size=2><FONT face="Consolas, Courier New, Courier"><SPAN style="FONT-SIZE: 10pt">_________________________________________________________________________<BR>Professional FreeSWITCH Consulting Services:<BR><A href="https://mail.tritonwest.net:442/webmail/consulting@freeswitch.org">consulting@freeswitch.org</A><BR><A href="http://www.freeswitchsolutions.com/">http://www.freeswitchsolutions.com</A><BR><BR>FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR><A href="http://www.cudatel.com/">http://www.cudatel.com</A><BR><BR>Official FreeSWITCH Sites<BR><A href="http://www.freeswitch.org/">http://www.freeswitch.org</A><BR><A href="http://wiki.freeswitch.org/">http://wiki.freeswitch.org</A><BR><A href="http://www.cluecon.com/">http://www.cluecon.com</A><BR><BR>FreeSWITCH-users mailing list<BR><A href="https://mail.tritonwest.net:442/webmail/FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A><BR><A href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A href="http://www.freeswitch.org/">http://www.freeswitch.org</A><BR></SPAN></FONT></FONT></BLOCKQUOTE><FONT size=2><FONT face="Consolas, Courier New, Courier"><SPAN style="FONT-SIZE: 10pt"><BR></SPAN></FONT></FONT><FONT face="Monaco, Courier New"><SPAN style="FONT-SIZE: 11pt">-- <BR>Ken<BR><FONT color=#0000ff><U><A href="http://www.freeswitch.org/">http://www.FreeSWITCH.org</A><BR><A href="http://www.cluecon.com/">http://www.ClueCon.com</A><BR><A href="http://www.ostag.org/">http://www.OSTAG.org</A><BR></U></FONT>irc.freenode.net #freeswitch<BR></SPAN></FONT></BLOCKQUOTE>
<STYLE>
</STYLE>
<DIV> </DIV>
<DIV> </DIV></body></html>