Differences

This shows you the differences between two versions of the page.

--- v5:database:microsoft_sql_server [2018/07/08 01:24] – mnewnham
+++ v5:database:microsoft_sql_server [2022/11/15 02:13] (current) – [Common Connection Problems] mnewnham
@@ Line 2: / Line 2: @@
 ~~NOTOC~~
 ===== Description =====
-There are 2 supported drivers that allow connections to Microsoft SQL Server databases.
+There are 2 supported drivers that allow connections to Microsoft SQL Server databases from SQL Server 2005 upwards.
 ==== mssqlnative ====
 This driver, which runs on both Windows and Linux clients, allows connections to Microsoft SQL Server databases versions 2008 and up, and uses the Microsoft Native Client libraries. This driver is recommended for Windows Clients running PHP 5.3 and higher, and Linux Clients running PHP 7.0 and higher, and provides the fastest PHP connection.
@@ Line 12: / Line 12: @@
 More about the FreeTDS libraries [[http://www.freetds.org/|here]]
-==== SQL Server 2003 ====
-Connecting to SQL server 2003 creates a difficulty There is no support for native client connections, and the alternative method, using php_mssql.dll was removed in PHP 5.3. The only alternative is to use a generic ODBC driver that does not require the Microsoft Native Client libraries.
-------------------------------------
 ====== mssqlnative ======
 <WRAP right box round 300px>
@@ Line 28: / Line 26: @@
 [[v5:database:pdo#pdo_sqlsrv|PDO driver for SQL Server]]\\
 [[v5:database:odbc#odbc_mssql|ODBC driver for SQL Server]]\\
+== See Also ==
+[[v5:reference:connection:setconnectionparameter#sqlserver|setConnectionParameter()]]
 </WRAP>
@@ Line 74: / Line 74: @@
 $db->connect('SERVER\SQLEXPRESS',NULL,NULL,'NORTHWND');
 </code>
+===== Common Connection Problems =====
+Recent versions of SQL Server fail to connect with an error ''Message: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The certificate chain was issued by an authority that is not trusted.''
+This problem can be resolved by adding
+<code php>
+$db->setConnectionParameter('TrustServerCertificate',1);
+</code>
+before issuing the ''$db->connect()'' statement
 ------------------------------
 ===== How to create a connection under Linux =====
@@ Line 116: / Line 129: @@
 This driver provides access to Microsoft SQL Server databases from unix systems via Freetds
-{{tag>[SQL_Server unix active freetds]}}
+{{tag>[SQL_Server unix active freetds tier1]}}
 --------------------------------------
 ===== mssql (Windows) =====