IIS 上的 MSSQL 和 PHP 5.3.5 之间的连接不起作用

2021-12-19 00:00:00 dll php iis sql-server

我最近安装了 IIS、PHP 5.3.5 和 MySQL,并且一切正常.

然后我也需要使用 MS SQL,我原以为很容易的任务现在让我发疯了,我不知道如何让它工作.

根据 php_info() 没有加载 MS SQL 驱动程序.

我下载了 php_mssql.dll 并在 php.ini 中启用了它,但它不起作用.我发现新版本的 PHP 使用了不同的 dll.所以我下载了新的,把它放在 ext 文件夹中,并更新了 php.ini,但仍然没有运气.

php_info() 仍未显示驱动程序已加载.

我将要卸载 IIS 和 PHP,然后安装我之前安装过的 Apache.

这个问题是我最后一次尝试,有人可以帮忙吗?

解决方案

这是我不久前写的客户常见问题解答的片段,以帮助我们的专用托管客户使用 MS SQL 驱动程序启动和运行 PHP.它可能会复制上面评论中已经传授的一些知识,但它的完整性也可以帮助其他人从头开始:

注意:很明显,自从我写这篇文章以来,PHP 版本号已经发生了一些变化,但一般原则仍然适用.

<小时>

安装先决条件:Microsoft Drivers for PHP for SQL Server 需要 SQL Native Client:

<块引用>

Microsoft SQL Server 2008 R2 Native Client X64 - 适用于 64 位 Windows

Microsoft SQL Server 2008 R2 Native Client X32 - 适用于 32 位 Windows

下载并安装与您的系统匹配的 Native Client 驱动程序.

PHP MS SQL 驱动程序:

为 SQL Server 下载适用于 PHP 的 Microsoft 驱动程序:

<块引用>

微软驱动程序用于 SQL Server 的 PHP

该文件是一个自解压可执行文件,因此只需使用 7zip 或 WinRAR 并将文件解压到您选择的文件夹中.我们现在需要决定选择与您的 PHP 安装相匹配的驱动程序.

PHP 5.3.5 有四种不同的版本:

  • PHP 5.3.5 非线程安全 VC9
  • PHP 5.3.5 非线程安全 VC6
  • PHP 5.3.5 线程安全 VC9
  • PHP 5.3.5 线程安全 VC6

要知道您安装的是哪个版本,请打开 snapshot.txt 文件,该文件与 php.exephp-cgi.exe 等.不要使用 notepad.exe,因为该文件在开头仅使用换行符 ( ) 作为行尾(unix 格式),而记事本会将它们合并为一行.

在文件中,您将看到一行(在第 6 行附近,或者在您使用记事本的第 1 行中间附近)以:Build::

开头<前>构建:D:php-sdksnap_5_3vc9x86objRelease - 非线程安全,VC9 构建构建:D:php-sdksnap_5_3vc6x86objRelease - 非线程安全,VC6 构建构建:D:php-sdksnap_5_3vc9x86objRelease_TS - 线程安全,VC9 构建构建:D:php-sdksnap_5_3vc6x86objRelease_TS - 线程安全,VC6 构建

这会告诉我们您正在运行的 PHP 版本.

从您提取 MS SQL PHP 驱动程序的文件夹中,选择与正在使用的 PHP 版本匹配的驱动程序(如果您不使用 PDO,则无需复制 php_pdo_ 驱动程序):

<前>PHP 5.3.5 非线程安全 VC9:php_sqlsrv_53_nts_vc9.dll、php_pdo_sqlsrv_53_nts_vc9.dllPHP 5.3.5 非线程安全 VC6:php_sqlsrv_53_nts_vc6.dll、php_pdo_sqlsrv_53_nts_vc6.dllPHP 5.3.5 线程安全 VC9:php_sqlsrv_53_ts_vc9.dll、php_pdo_sqlsrv_53_ts_vc9.dllPHP 5.3.5 线程安全 VC6:php_sqlsrv_53_ts_vc6.dll、php_pdo_sqlsrv_53_ts_vc6.dll

假设您的 PHP 安装位于 C:PHP,请将这些文件复制(不要移动)到您的 C:PHPEXT 文件夹.

打开C:PHPPHP.INI并找到文件的Dynamic Extensions部分并添加:

<前>扩展名=php_sqlsrv_53_nts_vc9.dll扩展名=php_pdo_sqlsrv_53_nts_vc9.dll <-- 可选

最后,为了确保 PHP 可以找到这些扩展,请确保 C:PHPPHP.INI 中的 extension_dir 指令设置为 C:PHPEXT:

<前>extension_dir = C:PHPext

重新启动 IIS 并调用 phpinfo().如果一切顺利,您应该会看到:

如果您还加载了 PDO 驱动程序,您应该看到:

I recently installed IIS, PHP 5.3.5 and MySQL, and had it all working.

I then has a requirement for MS SQL as well, and what I thought would be an easy task, is now driving me crazy and I can't figure out how to make it work.

According to php_info() the MS SQL drivers aren't loading.

I downloaded php_mssql.dll and enabled it in php.ini but it didn't work. I found out that the new version of PHP uses a different dll. So I downloaded the new one, put that in the ext folder, and updated the php.ini, but still no luck.

php_info() still isn't showing the drivers are loaded.

I am about to uninstall IIS and PHP, and install Apache, which I've installed before.

This question is my last attempt, can anyone help?

解决方案

This is a snippet from a customer FAQ I wrote up a wee while ago to help our dedicated hosting customers get PHP up and running with the MS SQL Drivers. It may duplicate some knowledge already imparted in the comments above, but it's completeness may also help others starting from scratch:

Note: Clearly the PHP version numbers have moved on a bit since I wrote this but the general principles still apply.


Installation Pre-requisite: The SQL Native Client is required for the Microsoft Drivers for PHP for SQL Server:

Microsoft SQL Server 2008 R2 Native Client X64 - for 64 bit Windows
or
Microsoft SQL Server 2008 R2 Native Client X32 - for 32 bit Windows

Download and install the Native Client driver that matches your system.

PHP MS SQL Drivers:

Download the Microsoft Drivers for PHP for SQL Server:

Microsoft Drivers for PHP for SQL Server

The file is a self-extracting executable so just use 7zip or WinRAR and extract the files to a folder of your choice. We now need to decide which driver to choose that matches your PHP installation.

PHP 5.3.5 comes in four different flavours:

  • PHP 5.3.5 Non-threadsafe VC9
  • PHP 5.3.5 Non-threadsafe VC6
  • PHP 5.3.5 Threadsafe VC9
  • PHP 5.3.5 Threadsafe VC6

To tell which version you have installed open the snapshot.txt file which lives in the same folder as php.exe, php-cgi.exe etc. Don't use notepad.exe because the file uses just line feed ( ) for line ends (unix format) at the start and notepad mangles these into a single line.

In the file you will see a line (around line 6, or near the middle of line 1 of you did use notepad) starting with: Build::

Build: D:php-sdksnap_5_3vc9x86objRelease - non-threadsafe, VC9 build
Build: D:php-sdksnap_5_3vc6x86objRelease - non-threadsafe, VC6 build
Build: D:php-sdksnap_5_3vc9x86objRelease_TS - threadsafe, VC9 build
Build: D:php-sdksnap_5_3vc6x86objRelease_TS - threadsafe, VC6 build

This tells us what version of PHP you're running.

From the folder you extracted the MS SQL PHP drivers, choose the driver(s) that matches the version of PHP being used (if you're not using PDO then you don't need to copy the php_pdo_ drivers):

PHP 5.3.5 Non-threadsafe VC9: php_sqlsrv_53_nts_vc9.dll, php_pdo_sqlsrv_53_nts_vc9.dll
PHP 5.3.5 Non-threadsafe VC6: php_sqlsrv_53_nts_vc6.dll, php_pdo_sqlsrv_53_nts_vc6.dll
PHP 5.3.5 Threadsafe VC9: php_sqlsrv_53_ts_vc9.dll, php_pdo_sqlsrv_53_ts_vc9.dll
PHP 5.3.5 Threadsafe VC6: php_sqlsrv_53_ts_vc6.dll, php_pdo_sqlsrv_53_ts_vc6.dll

Assuming your PHP installation lives in C:PHP, copy (DON'T MOVE) these files to your C:PHPEXT folder.

Open C:PHPPHP.INI and locate the Dynamic Extensions part of the file and add:

extension=php_sqlsrv_53_nts_vc9.dll
extension=php_pdo_sqlsrv_53_nts_vc9.dll   <-- optional

Finally, to be sure that PHP can find these extensions, ensure the extension_dir directive in C:PHPPHP.INI is set to C:PHPEXT:

extension_dir = C:PHPext

Restart IIS and call phpinfo(). If all is well you should see:

And if you also loaded the PDO driver you should see:

相关文章