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... 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. If you want to replace config (Directlry, Dialplan, other config...) you have a few options. Use mod_xml_curl, and do it real time w/ HTTP and an external app. Use one of the scriptiong languages that allow you to configure a script to run to generate the XML on the fly. 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. 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. --Dave _____ From: Andre Demattia [mailto:andretodd@verizon.net] To: FreeSWITCH Users Help [mailto:freeswitch-users@lists.freeswitch.org] Sent: Tue, 26 Mar 2013 11:13:24 -0700 Subject: Re: [Freeswitch-users] Freeswitch + MSSQL I'm using windows. Will that still work? I also want to use the manage lib in c# but I can't find anything worth wile for examples. I see a post that has <param name= "core-dbtype" value ="mdsql"> Not sure the steps for setting it up and where the SQL goes. _____ From: Ken Rice Sent: 3/26/2013 2:00 PM To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] Freeswitch + MSSQL 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 On 3/26/13 12:54 PM, "Andre Demattia" <andretodd@verizon.net> wrote: 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. _____ From: Dave R. Kompel <mailto:drk@drkngs.net> Sent: 3/26/2013 1:39 PM To: FreeSWITCH Users Help <mailto:freeswitch-users@lists.freeswitch.org> Subject: Re: [Freeswitch-users] Freeswitch + MSSQL Connect it how? Use it for the internal database, or do other things with it, such as User databases, call routing etc...? --Dave _____ From: Andre Demattia [mailto:andretodd@verizon.net] To: freeswitch-users@lists.freeswitch.org [mailto:freeswitch-users@lists.freeswitch.org] Sent: Tue, 26 Mar 2013 08:49:25 -0700 Subject: Re: [Freeswitch-users] Freeswitch + MSSQL HI, I'm new to Freeswitch and need to know how to connect my Windows Freeswitch to MSSQL. Can you share your example and step by step instructions ? I assume I need a Mod? Thanks _____ _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org -- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch