<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Andrew,<br>
<br>
thanks for your response :)<br>
<br>
I have got the connection to the server working and tested (isql
dnsname username password), and this works fine. The part that I am
missing is how to then set Opensips to use this connection rather
than a MySql connection.<br>
<br>
In the opensipsctlrc file, the DBENGINE is set to MYSQL, but I'm
guessing it should be changed to something like UNIXODBC or FREETDS
(both tried and a few other alternatives), but these are not
recognised. I have seen in some forums that people have it working
off of MS SQL, but sadly no examples :( <br>
<br>
thanks<br>
Matt<br>
<br>
<div class="moz-cite-prefix">On 09/05/2014 12:54, Andrew Cassidy
wrote:<br>
</div>
<blockquote
cite="mid:CAMbW9oJjG1_Pc9=opRkp2bh0gfYhroM43K86h1qkcvLpPDKWeQ@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a moz-do-not-send="true" href="http://www.cudatel.com"
target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a moz-do-not-send="true" href="http://www.freeswitch.org"
target="_blank">http://www.freeswitch.org</a><br>
<a moz-do-not-send="true" href="http://wiki.freeswitch.org"
target="_blank">http://wiki.freeswitch.org</a><br>
<a moz-do-not-send="true" href="http://www.cluecon.com"
target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a moz-do-not-send="true" 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 moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
href="http://www.cassidywebservices.co.uk"
target="_blank">www.cassidywebservices.co.uk</a></div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a class="moz-txt-link-freetext" href="http://www.cudatel.com">http://www.cudatel.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
<br>
</body>
</html>