PDO sqlsrv for PHP 7.3

Some time you need old-school... So, PDO sqlsrv for PHP 7.3 on Centos 7

Example what I need to make alive
$mssql = new PDO('sqlsrv:database=$database;server=$server,$port',$username,$password);
For the first - big surprise and present for me from MS. Good documentation and no broken links... Respect!


Install PHP 7.3.14 from Remi (I configure php from remi different then is described in documentation, I'll write HowTo and why)
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo
ACCEPT_EULA=Y yum install -y epel-release msodbcsql17 mssql-tools unixODBC-devel php-pear php-devel
pecl channel-update pecl.php.net
pecl install sqlsrv pdo_sqlsrv
INI files for PHP
echo "extension=pdo_sqlsrv.so" >> /etc/php.d/30-pdo_sqlsrv.ini
echo "extension=sqlsrv.so" >> /etc/php.d/30-pdo_sqlsrv.ini
And that all. Work fine.
# php -i | grep -i sqlsrv
Registered PHP Streams => https, ftps, compress.zlib, php, file, glob, data, http, ftp, compress.bzip2, phar, sqlsrv, zip
PDO drivers => dblib, mysql, sqlite, sqlsrv
pdo_sqlsrv support => enabled
pdo_sqlsrv.client_buffer_max_kb_size => 10240 => 10240
pdo_sqlsrv.log_severity => 0 => 0
sqlsrv support => enabled
sqlsrv.ClientBufferMaxKBSize => 10240 => 10240
sqlsrv.LogSeverity => 0 => 0
sqlsrv.LogSubsystems => 0 => 0
sqlsrv.WarningsReturnAsErrors => On => On


Popular posts from this blog

FreeRadius and Google Workspace LDAP