<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_1_1420985218167_5094"><span></span></div><div class="" style="" id="yui_3_16_0_1_1420985218167_5131">That's just what I was wondering but I cannot find any good info on the Microsoft SQL Linux driver as far as what switches I can put in the odbc.ini.....do you have any experience with that? Is there a parallel=yes option? &nbsp;&nbsp;</div><div id="yui_3_16_0_1_1420985218167_5118" class="" style="" dir="ltr"><br></div><div id="yui_3_16_0_1_1420985218167_5118" class="" style="" dir="ltr">Here is what I have in the odbcinst.ini</div><div id="yui_3_16_0_1_1420985218167_5118" class="" style=""><br></div><div class="" style="" id="yui_3_16_0_1_1420985218167_5130">[SQL Server Native Client 11.0]</div><div class="" style="" id="yui_3_16_0_1_1420985218167_5129">Description=Microsoft SQL Server ODBC Driver V1.0 for Linux</div><div class="" style="" id="yui_3_16_0_1_1420985218167_5128">Driver=/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0</div><div class="" style="" id="yui_3_16_0_1_1420985218167_5127">Threading=0</div><div class="" style="" id="yui_3_16_0_1_1420985218167_5159">UsageCount=1&nbsp;</div><div class="" style="" id="yui_3_16_0_1_1420985218167_5160"><br></div><div class="" style="" dir="ltr" id="yui_3_16_0_1_1420985218167_5191"><br></div>  <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1420985218167_5097"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1420985218167_5096"> <div dir="ltr" id="yui_3_16_0_1_1420985218167_5095"> <hr size="1">  <font size="2" face="Arial" id="yui_3_16_0_1_1420985218167_5098"> <b><span style="font-weight:bold;">From:</span></b> Nick Gorham &lt;nick@lurcher.org&gt;<br> <b><span style="font-weight: bold;">To:</span></b> unixodbc-support@mailman.unixodbc.org <br> <b><span style="font-weight: bold;">Sent:</span></b> Sunday, January 11, 2015 6:18 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [unixODBC-support] Multi-Threading issue with SQL Server<br> </font> </div> <div class="y_msg_container" id="yui_3_16_0_1_1420985218167_5099"><br><div id="yiv2311007593"><div id="yui_3_16_0_1_1420985218167_5100">
    <div class="qtdSeparateBR"><br><br></div><div class="yiv2311007593yqt8668232502" id="yiv2311007593yqt11220"><div class="yiv2311007593moz-cite-prefix" id="yui_3_16_0_1_1420985218167_5113">On 10/01/15 12:57, Roger Bellegarde
      wrote:<br clear="none">
    </div>
    <blockquote type="cite" id="yui_3_16_0_1_1420985218167_5102">
      <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;" id="yui_3_16_0_1_1420985218167_5101">
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style="">Hello
          all,</div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style=""><br clear="none" class="yiv2311007593" style="">
        </div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style="">Having
          an issue where queries sent to a Microsoft SQL server appear
          to be single threaded.</div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style="">When
          using a previous ODBC manager (progress odbc) &nbsp;the queries
          were processing&nbsp;</div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style="">multi-threaded</div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style=""><br clear="none" class="yiv2311007593" style="">
        </div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style="">My
          setup is as follows:</div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style=""><br clear="none" class="yiv2311007593" style="">
        </div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style="">UNIXODBC&nbsp;</div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style="">Oracle
          DG4ODBC Gateway</div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style="">Microsoft
          SQL Server for Linux</div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style=""><br clear="none" class="yiv2311007593" style="">
        </div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style="">Are
          there any switches/options at the UNIXODBC Layer that control
          this behavior?</div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style=""><br clear="none" class="yiv2311007593" style="">
        </div>
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style="">thanks
          in advance</div>
      </div>
    </blockquote></div>
    <br clear="none">
    Depends on the version of unixODBC. Many years ago it would single
    thread the calls, but the defaut has been not to do that for some
    time. <br clear="none">
    <br clear="none">
    Are you sure the change is not caused by the driver instead of the
    driver manager?<br clear="none">
    <br clear="none">
    -- <br clear="none">
    Nick<br clear="none">
    <br clear="none">
    <br clear="none">
    <blockquote type="cite" id="yui_3_16_0_1_1420985218167_5104">
      <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;" id="yui_3_16_0_1_1420985218167_5103">
        <div class="yiv2311007593" id="yiv2311007593yui_3_16_0_1_1420882050432_17618" style=""><br clear="none" class="yiv2311007593" style="">
        </div>
      </div>
      <br clear="none">
      <fieldset class="yiv2311007593mimeAttachmentHeader" id="yui_3_16_0_1_1420985218167_5105"></fieldset>
      <br clear="none">
      <pre id="yui_3_16_0_1_1420985218167_5112">_______________________________________________
unixODBC-support mailing list
<a rel="nofollow" shape="rect" class="yiv2311007593moz-txt-link-abbreviated" ymailto="mailto:unixODBC-support@mailman.unixodbc.org" target="_blank" href="mailto:unixODBC-support@mailman.unixodbc.org">unixODBC-support@mailman.unixodbc.org</a>
<a rel="nofollow" shape="rect" class="yiv2311007593moz-txt-link-freetext" target="_blank" href="http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support">http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support</a>
</pre>
    </blockquote>
    <br clear="none">
  </div></div><br><div class="yqt8668232502" id="yqt34739">_______________________________________________<br clear="none">unixODBC-support mailing list<br clear="none"><a shape="rect" ymailto="mailto:unixODBC-support@mailman.unixodbc.org" href="mailto:unixODBC-support@mailman.unixodbc.org">unixODBC-support@mailman.unixodbc.org</a><br clear="none"><a shape="rect" href="http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support" target="_blank">http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support</a><br clear="none"></div><br><br></div> </div> </div>  </div></body></html>