Rootop 服务器运维与web架构

php7.2安装pdo_sqlsrv连接mssql模块

数据库为 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

作者:Venus

服务器运维与性能优化

评论已关闭。