You first need to set up the TDS connection in /etc/freetds/freetds.conf Then set up the DSN in /etc/odbc.ini (and possibly /etc/odbcinst.ini) examples (Debian Whezy): /etc/freetds/freetds.conf [global] text size = 64512 [<arbitrary label>] host = <hostname or ip address> port = 1433 tds version = 7.2 /etc/odbc.ini [ODBC Data Sources] [<dsn name>] Servername = <label from freetds.conf> Database = <database name> Driver = FreeTDS /etc/odbcinst.ini [FreeTDS] Description = TDS driver (Sybase/MS SQL) Driver = libtdsodbc.so Setup = libtdsS.so CPTimeout = CPReuse = On 9 May 2014 09:58, Matt Broad <matt@inveroak.com> wrote:
Hi,
not strictly a Freeswitch question, so apologies, but just wanted to know if anyone has any experience using opensips and connecting to a microsoft sql database instead of MySql? I can see that there is an odbc module, which I assume using freetds and unixodbc, should be able to do the job. But I can't find any examples of people who aren't using Mysql.
Any pointers would be very much appreciated :)
thanks Matt
_________________________________________________________________________ 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
-- *Andrew Cassidy BSc (Hons) MBCS SSCA* Managing Director *T <info@cassidywebservices.co.uk> *03300 100 960 *F <info@cassidywebservices.co.uk> *03300 100 961 *E <info@cassidywebservices.co.uk> *andrew@cassidywebservices.co.uk *W <info@cassidywebservices.co.uk> *www.cassidywebservices.co.uk