我的环境是在win10下Php 连接SqlServer,报错如下
SQLSTATE[IMSSP]: This extension requires the Microsoft ODBC Driver for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver for SQL Server for x64: https://go.microsoft.com/fwlink/?LinkId=163712
一开始我安装了 下载 Microsoft ODBC Driver 18 for SQL Server (x64)
发现一直运行不了,所以一定要安装17 版本
进入ODBC数据源管理程序,点击 系统DSN 添加 SQL server ,链接sql服务器
php 中的 phpstudy_pro\Extensions\php\php7.3.4nts\ext中安装 php_pdo_sqlsrv_73_nts_x64.dll,php.ini 开启 pdo_sqlsrv_73_nts_x64.dll
https://docs.microsoft.com/en-us/sql/connect/php/download-drivers-php-sql-server?view=sql-server-2017