Comment 0 for bug 1727572

Revision history for this message
Sungtae Choi (sungtae542) wrote :

The freetds 0.9X version has a 1% chance of a mssql connection bug.

Please upgrade to freetds version 1.00.44 or later.

OS: Ubuntu 14.04, freetds 0.91, PHP5, MSSQL

Bug Message: SQLSTATE[01002] Adaptive Server connection failed (severity 9)

Bug fequency: 0.5% ~ 1%

Bug Content: freetds changelog
--------------------------------------------------
Author: Frediano Ziglio <email address hidden>
Date: Tue May 2 23:26:24 2017 +0100

    Fix very big login packet using MSSQL

    If login packet is really big to split into multiple TDS packets
    and is encrypted MSSQL only encrypt the first TDS packet, the others
    are not encrypted.
--------------------------------------------------

Bug Fix: Upgrade default freetds verion plz.

My Web Service sometimes error message "SQLSTATE[01002] Adaptive Server connection failed (severity 9)"

I saved it to a log file when connection an error occurred. (Error time, Error Url, Error message)

0.5%~ 1% connection error occurs.

I view freetds changelog file and upgradep freetds 1.00.44 version.

then error never occur for 3 months.

So, Please upgrade default freetds version.