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 03300 100 960  F 03300 100 961