php5.3 connects to sqlserver2005

Operating system win2003
Server: iis
php 5.3.26 sqlserver2005

After php5.3, sqlserver no longer supports connection extensions, but Microsoft officially has an extension solution for php5.3 and later.
1. Confirm that the database version to be connected to sqlserver is 2005
2. Confirm whether php supports vc9 or vc6, which can be seen from phpinfo().
3. Confirm that the version of php is 5.3, and confirm whether php is thread-safe, which can be seen in phpinfo().
3. Go to Microsoft official website to download the extension according to the above. Or download the attachment directly.


Points 2 and 3 can be seen in the Zend Extension Build attribute in phpinfo.
For example: API220090626, TS, VC9 TS stands for thread safety, an extension of the VC9 version.
API220090626, NTS, VC6 NTS stands for non-off-the-shelf security, an extension of the VC6 version.


TS,VC9 Assign the two extensions php_pdo_sqlsrv_53_ts_vc9.dll and php_sqlsrv_53_ts_vc9.dll to the php/ext directory.
TS,VC6 Assign the two extensions php_pdo_sqlsrv_53_ts_vc6.dll and php_sqlsrv_53_ts_vc6.dll to the php/ext directory.
NTS,VC9 Assign the two extensions php_pdo_sqlsrv_53_nts_vc9.dll and php_sqlsrv_53_nts_vc9.dll to the php/ext directory.
NTS, VC6 Assign the two extensions php_pdo_sqlsrv_53_nts_vc6.dll and php_sqlsrv_53_nts_vc6.dll to the php/ext directory.

At the same time, open the php.ini file and write the following code
extension = the pdo extension copied under ext // must correspond
extension = the extension copied under ext // must correspond
 One php_pdo_sqlsrv corresponds to one php_sqlsrv

After completing the above operations. Restart iis.
Open phpinfo();
You can query the PDO pdo item including sqlsrv
Query pdo_sqlsrv
If all of the above exist, php5.3 has successfully connected to sqlserver2005. .
Then write an instance to test the connection and the test is successful.