Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Issue

Zend Server 9 and higher includes PHP version 7, which no longer provides support for the old mssql extension to connect to Microsoft SQL Server databases.  Instead, the pdo_dblib extension can be used. 

Environment

Zend Server for IBM i version 9 and higher, running on any supported version of IBM i OS.

Resolution

In order to connect to a Microsoft SQL Server using PHP 7, you will need to use the pdo_dblib extension.  This is because the authors of the mssql extension decided that procedural processing should be deprecated and everyone should use the object oriented PDO method to access the data.  So, they opted to not upgrade mssql to be compatible with PHP 7.

...