[Freeswitch-users] Opensips using ODBC

[Andrew Cassidy]

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 at 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 at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at 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 at cassidywebservices.co.uk> *03300 100 960  *F
<info at cassidywebservices.co.uk> *03300 100 961
*E <info at cassidywebservices.co.uk> *andrew at cassidywebservices.co.uk
*W <info at cassidywebservices.co.uk> *www.cassidywebservices.co.uk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140509/6151009e/attachment.html