数据库为 SQL Server 2016 Web版 云数据库
# 设置yum源安装odbc
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo yum remove unixODBC unixODBC-devel yum install -y msodbcsql17 yum install -y mssql-tools yum install -y unixODBC-devel
# 配置php加载模块( php.ini )
下载对应php版本的模块 https://github.com/microsoft/msphpsql/releases/download/v5.8.1/CentOS7-7.2.tar
extension=/xxx/xxx/php_pdo_sqlsrv_72_nts.so extension=/xxx/xxx/php_sqlsrv_72_nts.so
重启php
参考:
https://docs.microsoft.com/zh-cn/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16#redhat17
https://docs.microsoft.com/en-us/sql/connect/php/system-requirements-for-the-php-sql-driver?redirectedfrom=MSDN&view=sql-server-ver16
原创文章,转载请注明。本文链接地址: https://www.rootop.org/pages/5061.html