<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Andrew,<br>
<br>
sorry for the delay in coming back to you. You are correct in that
the odbc module should be used :)<br>
The only issue I have is that you seemingly cannot create the tables
directly to mssql, but have to amend the mysql files .<br>
<br>
<br>
thanks<br>
Matt<br>
<br>
<div class="moz-cite-prefix">On 09/05/2014 16:48, Andrew Cassidy
wrote:<br>
</div>
<blockquote
cite="mid:CAMbW9oKeE3XhzJQL9yBdYzL-Z1++DMHjnNu3k1R_=ahy741xLQ@mail.gmail.com"
type="cite">
<div dir="ltr">The documentation for the odbc module: <a
moz-do-not-send="true"
href="http://www.opensips.org/html/docs/modules/devel/db_unixodbc.html">http://www.opensips.org/html/docs/modules/devel/db_unixodbc.html</a>
<div><br>
</div>
<div>looks like you should set it to <span
style="background-color:rgb(254,254,238);color:rgb(0,0,0)">unixodbc</span></div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On 9 May 2014 15:14, 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">
<div 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<span class="HOEnZb"><font color="#888888"><br>
Matt</font></span>
<div>
<div class="h5"><br>
<br>
<div>On 09/05/2014 12:54, Andrew Cassidy wrote:<br>
</div>
<blockquote 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"
target="_blank">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"
target="_blank">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><a
moz-do-not-send="true"
href="tel:03300%20100%20960"
value="+443300100960" target="_blank">03300
100 960</a> <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><a
moz-do-not-send="true"
href="tel:03300%20100%20961"
value="+443300100961" target="_blank">03300
100 961</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">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></fieldset>
<br>
<pre>_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a moz-do-not-send="true" href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a>
<a moz-do-not-send="true" href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a moz-do-not-send="true" href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a>
Official FreeSWITCH Sites
<a moz-do-not-send="true" href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
<a moz-do-not-send="true" href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a>
<a moz-do-not-send="true" href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a moz-do-not-send="true" href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a>
<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>
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>
<a moz-do-not-send="true" href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
<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>
<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>