Add MS SQL Server options for TrustServerCertificate and Encrypt#559
wpDataTables will not work with MS SQL Server unless I make the following patch to class.connection.php, which I have to reapply with each wpDataTables version upgrade:
switch ($vendor) case (self::$MSSQL):
if (isset($driver) && $driver == ‘sqlsrv’) return new PDOSql($vendor, “$driver:Server=$host,$port;Database=$database; TrustServerCertificate=True; Encrypt=false”, $user, $password);
}
If TrustServerCertificate and Encrypt values were options or there was a WordPress filter for the connection string, this would solve this problem.
Hi, thank you for your time! Since we have a hook that could resolve this issue, the best approach would be to contact our support team via Gleep (our AI support tool) on the website or open a ticket — our support agents will assist you and provide all necessary details.