config Use MS SQL SERVER 2005 2008.

Tutorials

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-caae6cf2ca05](http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=80e44913-24b4-4113-8807-caae6cf2ca05 "MS ") 2. setup or release it.
 
 
 
 
3. read the manual, copy .dll to PHP Ext Dir, and enable this EXT in php.ini.
 
 
 
   I recommend 
 
   PDO drviers 2.0: if use MSSQL2005, need the Microsoft SQL Server 2008 R2 Native Client installed; Please read: System Requirements (Microsoft Drivers for PHP for SQL Server)
 
 
 
 
3. read the manual, copy .dll to PHP Ext Dir, and enable this EXT in php.ini.
 
 
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_vc69.dll] [php_sqlsrv_53_ts_vc69.dll]
 
4. config your web main config. like this.    If you use SQL SERVER 2005/2008  The 'connectionString'  is not diff.
 
 
 

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

// old MS PDO + MSSQL 2000:   //'connectionString' => 'mssql:host=HOSTNAME\SQLEXPRESS;dbname=Client', // new PDOMS PDO + MSSQL 2005 2008
'connectionString' => 'sqlsrv:Server=HOSTNAME\SQLEXPRESS;Database=Client',
'username' => 'sa',---
[my site: ...](www.WinPowerAssistant.com "www.WinPowerAssistant.com")