记录linux php连接sqlServel，出现“could not find driver”

1.安装ODBC驱动(官方文档)
2.安装sqlsrv和pdo_sqlsrv

1.安装ODBC驱动

1）添加安装源到本机
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo

2.）卸载部分包，避免冲突
yum remove unixODBC-utf16 unixODBC-utf16-devel

3）安装msodbcsql17包
ACCEPT_EULA=Y yum install msodbcsql17

3）安装mssql-tools包
ACCEPT_EULA=Y yum install mssql-tools

4)写入环境变量
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc

5)环境变量生效
source ~/.bashrc

6)安装unixODBC-devel包
sudo yum install -y php php-pdo php-devel php-pear unixODBC-devel

7)查看是否成功
cat /etc/odbcinst.ini

出现以下几行代码为成功
[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.4.so.1.1
UsageCount=1

2.安装sqlsrv和pdo_sqlsrv
1）sqlsrv我是直接安装,附上pecl地址，查找对应的php版本，我是php7.3

pecl install sqlsrv-5.9.0

2）pdo_sqlsrv我是源码安装的，附上pecl地址

1）获取
cd /usr/local/src

wget http://pecl.php.net/get/pdo_sqlsrv-5.9.0.tgz

tar -zxvf pdo_sqlsrv-5.9.0.tgz

cd pdo_sqlsrv-5.9.0
 
phpize

//php的安装路径
./configure --with-php-config=/usr/local/php/bin/php-config  && make && make install

3）修改php.ini，加入以下两行

extension=sqlsrv.so
extension=pdo_sqlsrv.so

然后重启一下

systemctl restart php

4）验证

phpinfo();打印一下,成功