<div dir="ltr">You first need to set up the TDS connection in /etc/freetds/freetds.conf<div><br></div><div>Then set up the DSN in /etc/odbc.ini (and possibly /etc/odbcinst.ini)</div><div><br></div><div>examples (Debian Whezy):</div>
<div><br></div><div>/etc/freetds/freetds.conf</div><div><br></div><div>[global]</div><div>text size = 64512</div><div><br></div><div>[<arbitrary label>]</div><div>host = <hostname or ip address></div><div>port = 1433</div>
<div>tds version = 7.2</div><div><br></div><div>/etc/odbc.ini</div><div><br></div><div>[ODBC Data Sources]<br></div><div><br></div><div>[<dsn name>]</div><div>Servername = <label from freetds.conf></div><div>Database = <database name></div>
<div>Driver = FreeTDS</div><div><br></div><div>/etc/odbcinst.ini</div><div><br></div><div><div>[FreeTDS]</div><div>Description = TDS driver (Sybase/MS SQL)</div><div>Driver = libtdsodbc.so</div><div>Setup = libtdsS.so</div>
<div>CPTimeout =</div><div>CPReuse =</div></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 9 May 2014 09:58, Matt Broad <span dir="ltr"><<a href="mailto:matt@inveroak.com" target="_blank">matt@inveroak.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
not strictly a Freeswitch question, so apologies, but just wanted to<br>
know if anyone has any experience using opensips and connecting to a<br>
microsoft sql database instead of MySql?<br>
I can see that there is an odbc module, which I assume using freetds and<br>
unixodbc, should be able to do the job. But I can't find any examples<br>
of people who aren't using Mysql.<br>
<br>
Any pointers would be very much appreciated :)<br>
<br>
thanks<br>
Matt<br>
<br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><b>Andrew Cassidy BSc (Hons) MBCS SSCA</b><div>Managing Director<div><div><img src="http://www.cassidywebservices.co.uk/static/emailsig.png"><br>
</div><div><br><div><b style="color:rgb(51,135,171);text-decoration:none;font-family:sans-serif"><a href="mailto:info@cassidywebservices.co.uk" style="color:rgb(51,135,171);text-decoration:none;font-family:sans-serif" target="_blank">T</a> </b>03300 100 960
<b style="color:rgb(51,135,171);text-decoration:none;font-family:sans-serif"><a href="mailto:info@cassidywebservices.co.uk" style="color:rgb(51,135,171);text-decoration:none;font-family:sans-serif" target="_blank">F</a> </b>03300 100 961</div>
<div><b style="text-decoration:none;font-family:sans-serif"><a href="mailto:info@cassidywebservices.co.uk" style="color:rgb(51,135,171);text-decoration:none;font-family:sans-serif" target="_blank">E</a> </b><a href="mailto:andrew@cassidywebservices.co.uk" target="_blank">andrew@cassidywebservices.co.uk</a></div>
<div><b style="text-decoration:none;font-family:sans-serif"><a href="mailto:info@cassidywebservices.co.uk" style="color:rgb(51,135,171);text-decoration:none;font-family:sans-serif" target="_blank">W</a> </b><a href="http://www.cassidywebservices.co.uk" target="_blank">www.cassidywebservices.co.uk</a></div>
</div></div></div></div>
</div>