Ubuntu下 PHP7.4 安装 mssql sqlsrv扩展以链接 SQL SERVER 数据库

piaoling  2024-09-13 17:23:36
1,设置源
sudo su

curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list > /etc/apt/sources.list.d/mssql-release.list

exit
2.安装SQL Server 2019驱动程序和相关工具
sudo apt update
sudo apt install unixodbc-dev msodbcsql17 mssql-tools
3.配置ODBC文件/etc/odbcinst.ini,添加以下内容
[MSSQL]
Description = Microsoft ODBC Driver 17 for SQL Server
Driver = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.8.so.1.1
UsageCount = 1
4.安装PHP的MSSQL扩展
查找php版本对应的扩展:http://pecl.php.net/package/pdo_sqlsrv
sudo pecl install sqlsrv-5.10.0
sudo pecl install pdo_sqlsrv-5.10.0

echo "extension=sqlsrv.so" | sudo tee -a /etc/php/7.4/cli/php.ini
echo "extension=pdo_sqlsrv.so" | sudo tee -a /etc/php/7.4/cli/php.ini

类别 :  默认(746)  |  浏览(297)  |  评论(0)
发表评论(评论将通过邮件发给作者):

Email: