Difference between #7 and #9 of
config Use MS SQL SERVER 2005 2008.

Revision #9 has been created by Asgaroth on Mar 14, 2012, 4:11:24 PM with the memo:

Updated links
« previous (#7) next (#10) »

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

[...]
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. 
 
   PDO drviers 2.0: if use MSSQL2005, **need Install **the [Microsoft SQL Server 2008 R2 Native Client installed**](http://www.microsoft.com/download/en/details.aspx?id=16978 "Native Client")**
 
 
   PDO drivers 2.0: if use MSSQL2005, ; 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',
[...]
3 0
8 followers
Viewed: 76 032 times
Version: 1.1
Category: Tutorials
Tags: mssql, SQL Server, sqlsrv
Written by: vcxz_1982
Last updated by: Asgaroth
Created on: May 11, 2011
Last updated: 12 years ago
Update Article
Revert to #7 | Revert to #9

Revisions

View all history