config Use MS SQL SERVER 2005 2008.

Tutorials

crt screensamssql, sqlsrv, SQL Server

Use SQL SERVER 2000, the date format not like: yyyy/mm/dd hh:mm:ss. So I change to use SQL SERVER 2008 EXPRESS. 1. download [PDO MS EXT from: [](http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=80e44913-24b4-4113-8807-caae6cf2ca05id=20098 "PDO MS Ext")
 
 
2. Install **the [Microsoft SQL Server 2008 R2 Native Client](http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=80e44913-24b4-4113-8807-caae6cf2ca05 "MS ")
 
 
2. setup or release it. 
 
   PDO drviers 2.0: if use MSSQL2005, **need the Microsoft SQL Server 2008 R2 Native Client installed**;id=16978 "Native Client")**
 
 
Please read: System Requirements (Microsoft Drivers for PHP for SQL Server)example:

 
- PHP 5.3.5 use: [php_pdo_sqlsrv_53_ts_vc6.dll] [php_sqlsrv_53_ts_vc6.dll] - PHP 5.3.6 use: [php_pdo_sqlsrv_53_ts_vc9.dll] [php_sqlsrv_53_ts_vc9.dll]
 
4. config_Note: If you are using WAMP use the thread safe (ts) version_
 
 
4. Update your web main config. like this.

```php
// PDO MSSQL
'db'=>array(
// 'class'=>'application.components.MyMsSqlConnection',