[PHP] Install Sqlserver driver and extention for PHP


Description
     Install driver and extention sql for php.

Requirement 
     -  OS x86 or 32 bit (XP , MS Win Server 2003)
     -  Apache (Wamp / XAMPP)

Sofware Download info :
    1. Microsoft sqlserver native client 2008 R2
    2. sqlserver extention support for php version under 5.4 but higher than 5.3
    3. if your php version higher 5.4, download extention here
        Microsoft Drivers 3.0 for PHP for SQL Server 

How to
    1. Download sqlserver native client 2008 R2 and sqlserver ext (Download Here)
    2. install sqlserver native client 2008 R2 or higher.
    3. in folder php extention (download in step-1) you will found file with name like
        -php_pdo_sqlsrv_53_ts_vc6.dll
        -php_sqlsrv_53_ts_vc6.dll
        -php_pdo_sqlsrv_53_nts_vc6.dll
        -php_sqlsrv_53_nts_vc6.dll
     here's the meaning :
          * 53 is the meaning for php version higher than 5.3
          * ts / nts (thread safe / non thread safe) , i preffered using thread safe but the default php is nts
          * vc6 , compiler visual c++ 6
     4. for example we use thread safe , so just 2 files we use (if you want use nts is okay )
        -php_pdo_sqlsrv_53_ts_vc6.dll
        -php_sqlsrv_53_ts_vc6.dll
     5. copy that file to C:\wamp\bin\php\php5.3.1\ext\[paste here] (WAMP)
     6. open php.ini and add this line :
         extension=php_pdo_sqlsrv_53_ts_vc6.dll
         extension=php_sqlsrv_53_ts_vc6.dll
     7. restart your webserver, and check the effect when connect sqlserver
     8. if still problem, may be u use OS like Win Server 2012 or later that need ODBC SQL. you can download msodbcsql HERE

NOTE :
     - please always read compatibility(OS) every software requirement before install the software. !!

Post a Comment

Harap gunakan bahasa yang baik dan sopan, terima kasih