config Use MS SQL SERVER 2005 2008.

Comparing #5 with #10

Tags

mssql, sqlsrv, SQL Server

Content

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 
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
[...]
---
[my site
...]( www.WinPowerAssistant.com ](http://www.WinPowerAssistant.com "http://www.WinPowerAssistant.com")