ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:database:microsoft_sql_server

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
v5:database:microsoft_sql_server [2020/01/13 12:38] – Add tier1 tag dregadv5:database:microsoft_sql_server [2022/11/15 02:12] – Added connection fix example mnewnham
Line 26: Line 26:
 [[v5:database:pdo#pdo_sqlsrv|PDO driver for SQL Server]]\\ [[v5:database:pdo#pdo_sqlsrv|PDO driver for SQL Server]]\\
 [[v5:database:odbc#odbc_mssql|ODBC driver for SQL Server]]\\ [[v5:database:odbc#odbc_mssql|ODBC driver for SQL Server]]\\
 +== See Also ==
 +[[v5:reference:connection:setconnectionparameter#sqlserver|setConnectionParameter()]]
 </WRAP> </WRAP>
  
Line 72: Line 74:
 $db->connect('SERVER\SQLEXPRESS',NULL,NULL,'NORTHWND'); $db->connect('SERVER\SQLEXPRESS',NULL,NULL,'NORTHWND');
 </code> </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('TrustedCertificate',1);
 +</code>
 +
 +before issuing the ''$db->connect()'' statement
 +
 +
 ------------------------------ ------------------------------
 ===== How to create a connection under Linux ===== ===== How to create a connection under Linux =====
v5/database/microsoft_sql_server.txt · Last modified: 2022/11/15 02:13 by mnewnham