[PHP] Install Sqlserver driver and extention for PHP
in
PHP
- on 11:24:00 AM
- No comments
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