PHP add mssql/sqlserver2000 Extension for php5.2/php5.3/php5.4

Original: PHP add mssql/sqlserver2000 extension for php5.2/php5.3/php5.4

This article describes how to configure a PHP extension under Windows.

This article links http://blog.csdn.net/uuleaf/article/details/7663424, reproduced please note the source

Environment configuration:

1. If you use the sqlserver2000 database, make sure to hit the sqlserver2000 SP4 patch, otherwise you will not be able to connect sqlserver2000 database

You can download to SP4 patch pack at http://www.microsoft.com/zh-cn/download/details.aspx?id=18290

Note: The author is planted in this place, must pay attention to hit SP4 patch, otherwise 1433 port can not open

2. Make sure that the Sqlserver2000 account has TCP/IP connection support and that port 1433 is already open

In the Enterprise Manager Tools Sql Server Configuration Properties network configuration, see if the TCP/IP protocol has been started.

3. Download the Ntwdblib.dll file and copy it to the C:\Windows\System32 directory.

If your PHP environment is on the same machine as the SQL Server servers, this step is skipped.

You can download to Ntwdblib.dll in http://www.kuaipan.cn/file/id_8112282689093624.html

4. View a version of PHP that has been downloaded from a third-party website since php5.3.6,php officially no longer provides MSSQL extensions for MSSQL. Microsoft currently offers its own php-mssql extension, but only supports sqlserver2005 and above, and sqlserver2000 is no longer supported like a posthumous child.

php5.2 Version Series Please skip this step directly

php5.3+ version of MSSQL driver is too little, on the http://www.mdome.org/category/programming/php/to provide php5.3.6\php5.3.10\php5.4.0 VC9 Threadsafe version of the MSSQL extension, tested available, you can also download here

   php5.3.6   MSSQL Extension x86 VC9 thread safe:   1  ext_mssql-5.3. 6   2 ext_mssql-5.3.6

   php5.3.10 mssql extension x86 vc9 thread safe:   1 ext_mssql-5.3.10 2    Ext_ mssql-5.3.10  

PHP5.4.0 MSSQL extension x86 VC9 thread safe: 1 ext_mssql-5.4.0 2 ext_mssql-5.4.0

5. Copy the downloaded Php_mssql.dll to the Ext folder in the PHP home directory, and modify the php.ini to open the MSSQL extension

#去掉前面分号即可 # Original:; extension=php_mssql.dll# modified: Extension=php_mssql.dll

6. Restart the HTTP service to see if there is an MSSQL extension in phpinfo ().

This article links php add mssql/sqlserver2000 extension, suitable for php5.2/php5.3/php5.4, reprint please note the source

PHP add mssql/sqlserver2000 Extension for php5.2/php5.3/php5.4