I am trying to move a legacy application (
CakePHP 2.5.5) running on
PHP 5.6 to a Docker container but I can't get the PDO driver for Microsoft SQL Server to work.
I have been searching around for hours but all install instructions seem to say that SQLSRV PDO driver is only supported by PHP 7.
I cannot run CakePHP 2.5.5 on PHP 7 so I have to make it work with PHP 5.6. (Unless someone knows how to make it work with PHP 7?)
I am using the official Docker PHP image for PHP 5.6 (
php:5.6-apache) which uses Debian 9 (stretch)
pecl install sqlsrv
But I get
pecl/sqlsrv requires PHP (version >= 7.1.0), installed version is 5.6.40
Then I tried
pecl install sqlsrv-3.0.1
But it fails.
I tried this https://gist.github.com/joecampo/acd1e5881aee08bd8959 but it didn't change anything.
Bottom line: I ask for help to make my CakePHP 2.5.5 work with the SQLSRV PDO driver in a docker container.