msphpsql: [Microsoft][ODBC Driver 17 for SQL Server]Encryption not supported on the client

Hi all, ODBC Driver 17.7.2 is available for download now. Please give it a try and let us know how it goes.

Yes, continuously hammering the server with requests for at least two days (sometimes longer) is what we do to reproduce this issue.

Yep, this matches my experience

@lwohlhart

There is a delay between when the English docs are updated for a release and when the localized pages get updated by the localization process. I don’t know what the typical lag is, but that’s the reason for this note on the download pages:

Regards, David

For everyone who is as confused as I was: Make sure you hit the english version of the ODBC Driver download page https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15 (in my case the german version still only offers 17.7.1)

@yitam I’ve been running our load test for a day now (with MARS enabled) and 17.7.2.1. Looking good so far! Will keep it running for another week and keep you posted. Thanks a lot @yitam !

@yitam Could you confirm that the issue has something in common with the MARS turned on and that’s why we should turn it off on production servers to mitigate? I’m asking because we need to decide if wait for ODBC final fix or apply the workaround. Thanks.

Hi @mbiebl and @ajdjackson, here is an update: we figured out a way to consistently reproduce the issue and found the underlying causes at long last. We are running different tests, including stress testing the server, to make sure the fix in the ODBC driver does not introduce regressions.

Basically only fetching:

$ grep pdo  -R
CardDAV/Backend/PDO.php:     * @param \PDO $pdo DB context
CardDAV/Backend/PDO.php:    public function __construct(\PDO $pdo,
CardDAV/Backend/PDO.php:        parent::__construct($pdo);
CardDAV/Backend/PDO.php:        $stmt = $this->pdo->prepare('SELECT principaluri FROM ' . $this->addressBooksTableName . ' WHERE id = ?');
CardDAV/Backend/PDO.php:        $stmt2 = $this->pdo->prepare('SELECT subject, permissions FROM permissions WHERE addressbookid = ?');
CardDAV/Backend/PDO.php:        if (strcasecmp($this->pdo->getAttribute(constant('PDO::ATTR_DRIVER_NAME')), 'sqlsrv') == 0) {
CardDAV/Backend/PDO.php:            $stmt = $this->pdo->prepare('SELECT TOP 1 id, carddata, uri, lastmodified, etag, size FROM ' . $this->cardsTableName . ' WHERE addressbookid = ? AND uri = ?');
CardDAV/Backend/PDO.php:            $stmt = $this->pdo->prepare('SELECT id, carddata, uri, lastmodified, etag, size FROM ' . $this->cardsTableName . ' WHERE addressbookid = ? AND uri = ? LIMIT 1');
CardDAV/Backend/PDO.php:        $stmt = $this->pdo->prepare('SELECT id, uri, displayname, principaluri, description, synctoken FROM ' . $this->addressBooksTableName . ' WHERE principaluri = ?');
CardDAV/Backend/PDO.php:        $shared = $this->pdo->prepare('SELECT id, uri, displayname, principaluri, description, synctoken FROM ' . $this->addressBooksTableName . ' WHERE shared = 1');
AD.php:    private $pdo = null;
AD.php:    function __construct(\PDO $pdo, $settingsTableName = 'systemsettings', $index = 1) {
AD.php:        $this->pdo = $pdo;
AD.php:        $stmt = $this->pdo->prepare('SELECT domainController, domainName, baseDN, directoryType, domainControllerUseSSL FROM ' . $settingsTableName . ' WHERE OID = ?');

i.e. nothing fancy

we use jmeter: https://jmeter.apache.org/