[egenix-users] Using mxodbc with SQL Server 2012

[M.-A. Lemburg]

On 03.09.2015 19:42, M.-A. Lemburg wrote:
> On 03.09.2015 13:28, M.-A. Lemburg wrote:
>> On 03.09.2015 12:06, Sheila Allen wrote:
>>> On Thu, Sep 3, 2015 at 4:16 AM, M.-A. Lemburg <mal at egenix.com> wrote:
>>>>
>>>> On 03.09.2015 08:44, Sheila Allen wrote:
>>>>>> I'm looking into the MS SQL Server Native client again as well, we
>>> tried
>>>>>> it when they first announced it and it would segfault with any
>>> significant
>>>>>> load
>>>>>
>>>>> We're currently testing the MS ODBC Driver for Linux, and ran into a
>>>>> similar segfault under load. This was resolved by upgrading unixODBC
>>> 2.3.0
>>>>> to 2.3.2, even though the MS ODBC Driver officially only supports 2.3.0.
>>>>>
>>>>> Some discussion of the issue here:
>>>>>
>>> https://social.msdn.microsoft.com/Forums/sqlserver/en-US/23fafa84-d333-45ac-8bd0-4b76151e8bcc/sql-server-driver-for-linux-causes-segmentation-fault
>>>>
>>>> We are using the MS driver with unixODBC 2.3.2 just fine. The only
>>>> segfault we've seen so far is related to using Unicode strings with
>>>> DriverConnect():
>>>>
>>>> http://www.egenix.com/products/python/mxODBC/doc/#_Toc427692959
>>>>
>>>> If you can provide instructions on how to reproduce the problem
>>>> you are seeing under load, we can try to investigate this some
>>>> more.
>>>
>>> The segfault issue goes away with 2.3.2, as mentioned above. This
>>> discussion describes how to reproduce the issue using the unixODBC 2.3.0:
>>>
>>> https://social.msdn.microsoft.com/Forums/sqlserver/en-US/23fafa84-d333-45ac-8bd0-4b76151e8bcc/sql-server-driver-for-linux-causes-segmentation-fault
>>
>> Thanks, we'll try to replicate this and then check with the
>> various unixODBC versions.
> 
> I just ran the following setup without segfaults:
> 
> * openSUSE Linux 13.1 x64
> * unixODBC 2.3.0
> * unixODBC .so.1 libs symlink'ed to .so.2 for compatibility
>   with mxODBC 3.3.5
> * MS ODBC driver 11.00.2270
> 
> Our test suite tries to create up to 100 connections all open
> at the same time.
> 
> Unlike the example in the above forum thread it uses DriverConnect().
> Perhaps that makes a difference.

Checked with Connect(): same result - no segfaults.

> Also note that the thread mentions a version 11.0.1790 of the MS
> ODBC driver. That was their first release of the Linux driver:
> 
> http://www.microsoft.com/en-us/download/details.aspx?id=28160
> 
> published in 2012.
> 
> So I guess the problem was on their side and not in unixODBC;
> or perhaps a combination of effects on both sides causing
> the problem.

Has anyone else observed intermittent problems with the combination
unixODBC + MS SQL Server Native Client 11.00.2270 ?

We're always keen on hearing about such problems with ODBC drivers
to be able address these using work-arounds in mxODBC.

Thanks,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Sep 03 2015)
>>> Python Projects, Coaching and Consulting ...  http://www.egenix.com/
>>> mxODBC Plone/Zope Database Adapter ...       http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2015-08-27: Released eGenix mx Base 3.2.9 ...     http://egenix.com/go83

::::: Try our mxODBC.Connect Python Database Interface for free ! ::::::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
               http://www.egenix.com/company/contact/