Changes
Title
unchanged
config Use MS SQL SERVER 2005 2008.
Category
unchanged
Tutorials
Yii version
unchanged
Tags
changed
crt screensamssql, sqlsrv, SQL Server
Content
changed
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/download
s/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/download
s/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 id=16978 "Native Client
installed;")**
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',[...]