PHP for SQL Server driver version → ↓ PHP version | 5.6 | 5.3 | 5.2 | 4.3 | 4.0 | 3.2 | 3.1 |
---|---|---|---|---|---|---|---|
7.3 | 7.3.0+ | ||||||
7.2 | 7.2+1 | 7.2+1 | 7.2+1 | ||||
7.1 | 7.1.0+ | 7.1.0+ | 7.1.0+ | 7.1.0+ | |||
7.0 | 7.0.0+ | 7.0.0+ | 7.0.0+ | 7.0.0+ | |||
5.6 | 5.6.4+ | ||||||
5.5 | 5.5.16+ | 5.5.16+ | |||||
5.4 | 5.4.32 | 5.4.32 |
PHP for SQL Server driver version → ↓ ODBC Driver version | 5.6 | 5.3 | 5.2 | 4.3 | 4.0 | 3.2 | 3.1 |
---|---|---|---|---|---|---|---|
ODBC Driver 17+ | Y | Y | Y | ||||
ODBC Driver 13.1 | Y | Y | Y | Y | Y | ||
ODBC Driver 13 | Y | ||||||
ODBC Driver 11 | Y | Y | Y | Y | Y | Y | Y |
PHP for SQL Server driver version → ↓ SQL Server version | 5.6 | 5.3 | 5.2 | 4.3 | 4.0 | 3.2 | 3.1 |
---|---|---|---|---|---|---|---|
Azure SQL Database | Y | Y | Y | Y | |||
Azure SQL Managed Instance | Y | Y | Y | Y | |||
Azure SQL Data Warehouse | Y | Y | Y | Y | |||
SQL Server 2017 | Y | Y | Y | Y | |||
SQL Server 2016 | Y | Y | Y | Y | Y | ||
SQL Server 2014 | Y | Y | Y | Y | Y | Y | Y |
SQL Server 2012 | Y | Y | Y | Y | Y | Y | Y |
SQL Server 2008 R2 | Y | Y | Y | Y | Y | Y | Y |
SQL Server 2008 | Y | Y | Y |
PHP for SQL Server driver version → ↓ Operating system | 5.6 | 5.3 | 5.2 | 4.3 | 4.0 | 3.2 | 3.1 |
---|---|---|---|---|---|---|---|
Windows Server 2016 | Y | Y | Y | Y | |||
Windows Server 2012 R2 | Y | Y | Y | Y | Y | Y | Y |
Windows Server 2012 | Y | Y | Y | Y | Y | Y | Y |
Windows Server 2008 R2 SP1 | Y | Y | Y | ||||
Windows Server 2008 SP2 | Y | Y | Y | ||||
Windows 10 | Y | Y | Y | Y | Y | ||
Windows 8.1 | Y | Y | Y | Y | Y | Y | Y |
Windows 8 | Y | Y | Y | Y | |||
Windows 7 SP1 | Y | Y | Y | ||||
Windows Vista SP2 | Y | Y | Y | ||||
Ubuntu 18.10 (64-bit) | Y | ||||||
Ubuntu 18.04 (64-bit) | Y | Y | |||||
Ubuntu 17.10 (64-bit) | Y | Y | |||||
Ubuntu 16.04 (64-bit) | Y | Y | Y | Y | Y | ||
Ubuntu 15.10 (64-bit) | Y | ||||||
Ubuntu 15.04 (64-bit) | Y | ||||||
Debian 9 (64-bit) | Y | Y | Y | ||||
Debian 8 (64-bit) | Y | Y | Y | Y | |||
Red Hat Enterprise Linux 7 (64-bit) | Y | Y | Y | Y | Y | ||
Suse Enterprise Linux 15 (64-bit) | Y | ||||||
Suse Enterprise Linux 12 (64-bit) | Y | Y | Y | ||||
macOS Mojave (64-bit) | Y | ||||||
macOS High Sierra (64-bit) | Y | Y | |||||
macOS Sierra (64-bit) | Y | Y | Y | Y | |||
macOS El Capitan (64-bit) | Y | Y | Y |
Driver file | PHP version | Thread safe? | Use with PHP .dll |
---|---|---|---|
32-bit php_sqlsrv_71_nts.dll 32-bit php_pdo_sqlsrv_71_nts.dll | 7.1 | no | 32-bit php7.dll |
32-bit php_sqlsrv_71_ts.dll 32-bit php_pdo_sqlsrv_71_ts.dll | 7.1 | yes | 32-bit php7ts.dll |
64-bit php_sqlsrv_71_nts.dll 64-bit php_pdo_sqlsrv_71_nts.dll | 7.1 | no | 64-bit php7.dll |
64-bit php_sqlsrv_71_ts.dll 64-bit php_pdo_sqlsrv_71_ts.dll | 7.1 | yes | 64-bit php7ts.dll |
32-bit php_sqlsrv_72_nts.dll 32-bit php_pdo_sqlsrv_72_nts.dll | 7.2 | no | 32-bit php7.dll |
32-bit php_sqlsrv_72_ts.dll 32-bit php_pdo_sqlsrv_72_ts.dll | 7.2 | yes | 32-bit php7ts.dll |
64-bit php_sqlsrv_72_nts.dll 64-bit php_pdo_sqlsrv_72_nts.dll | 7.2 | no | 64-bit php7.dll |
64-bit php_sqlsrv_72_ts.dll 64-bit php_pdo_sqlsrv_72_ts.dll | 7.2 | yes | 64-bit php7ts.dll |
32-bit php_sqlsrv_73_nts.dll 32-bit php_pdo_sqlsrv_73_nts.dll | 7.3 | no | 32-bit php7.dll |
32-bit php_sqlsrv_73_ts.dll 32-bit php_pdo_sqlsrv_73_ts.dll | 7.3 | yes | 32-bit php7ts.dll |
64-bit php_sqlsrv_73_nts.dll 64-bit php_pdo_sqlsrv_73_nts.dll | 7.3 | no | 64-bit php7.dll |
64-bit php_sqlsrv_73_ts.dll 64-bit php_pdo_sqlsrv_73_ts.dll | 7.3 | yes | 64-bit php7ts.dll |
Driver file | PHP version | Thread safe? |
---|---|---|
php_sqlsrv_71_nts.so php_pdo_sqlsrv_71_nts.so | 7.1 | no |
php_sqlsrv_71_ts.so php_pdo_sqlsrv_71_ts.so | 7.1 | yes |
php_sqlsrv_72_nts.so php_pdo_sqlsrv_72_nts.so | 7.2 | no |
php_sqlsrv_72_ts.so php_pdo_sqlsrv_72_ts.so | 7.2 | yes |
php_sqlsrv_73_nts.so php_pdo_sqlsrv_73_nts.so | 7.3 | no |
php_sqlsrv_73_ts.so php_pdo_sqlsrv_73_ts.so | 7.3 | yes |
Driver file | PHP version | Thread safe? | Use with PHP .dll |
---|---|---|---|
32-bit php_sqlsrv_7_nts.dll 32-bit php_pdo_sqlsrv_7_nts.dll | 7.0 | no | 32-bit php7.dll |
32-bit php_sqlsrv_7_ts.dll 32-bit php_pdo_sqlsrv_7_ts.dll | 7.0 | yes | 32-bit php7ts.dll |
64-bit php_sqlsrv_7_nts.dll 64-bit php_pdo_sqlsrv_7_nts.dll | 7.0 | no | 64-bit php7.dll |
64-bit php_sqlsrv_7_ts.dll 64-bit php_pdo_sqlsrv_7_ts.dll | 7.0 | yes | 64-bit php7ts.dll |
32-bit php_sqlsrv_71_nts.dll 32-bit php_pdo_sqlsrv_71_nts.dll | 7.1 | no | 32-bit php7.dll |
32-bit php_sqlsrv_71_ts.dll 32-bit php_pdo_sqlsrv_71_ts.dll | 7.1 | yes | 32-bit php7ts.dll |
64-bit php_sqlsrv_71_nts.dll 64-bit php_pdo_sqlsrv_71_nts.dll | 7.1 | no | 64-bit php7.dll |
64-bit php_sqlsrv_71_ts.dll 64-bit php_pdo_sqlsrv_71_ts.dll | 7.1 | yes | 64-bit php7ts.dll |
32-bit php_sqlsrv_72_nts.dll 32-bit php_pdo_sqlsrv_72_nts.dll | 7.2 | no | 32-bit php7.dll |
32-bit php_sqlsrv_72_ts.dll 32-bit php_pdo_sqlsrv_72_ts.dll | 7.2 | yes | 32-bit php7ts.dll |
64-bit php_sqlsrv_72_nts.dll 64-bit php_pdo_sqlsrv_72_nts.dll | 7.2 | no | 64-bit php7.dll |
64-bit php_sqlsrv_72_ts.dll 64-bit php_pdo_sqlsrv_72_ts.dll | 7.2 | yes | 64-bit php7ts.dll |
Driver file | PHP version | Thread safe? |
---|---|---|
php_sqlsrv_7_nts.so php_pdo_sqlsrv_7_nts.so | 7.0 | no |
php_sqlsrv_7_ts.so php_pdo_sqlsrv_7_ts.so | 7.0 | yes |
php_sqlsrv_71_nts.so php_pdo_sqlsrv_71_nts.so | 7.1 | no |
php_sqlsrv_71_ts.so php_pdo_sqlsrv_71_ts.so | 7.1 | yes |
php_sqlsrv_72_nts.so php_pdo_sqlsrv_72_nts.so | 7.2 | no |
php_sqlsrv_72_ts.so php_pdo_sqlsrv_72_ts.so | 7.2 | yes |
Driver file | PHP version | Thread safe? | Use with PHP .dll |
---|---|---|---|
32-bit php_sqlsrv_7_nts.dll 32-bit php_pdo_sqlsrv_7_nts.dll | 7.0 | no | 32-bit php7.dll |
32-bit php_sqlsrv_7_ts.dll 32-bit php_pdo_sqlsrv_7_ts.dll | 7.0 | yes | 32-bit php7ts.dll |
64-bit php_sqlsrv_7_nts.dll 64-bit php_pdo_sqlsrv_7_nts.dll | 7.0 | no | 64-bit php7.dll |
64-bit php_sqlsrv_7_ts.dll 64-bit php_pdo_sqlsrv_7_ts.dll | 7.0 | yes | 64-bit php7ts.dll |
32-bit php_sqlsrv_71_nts.dll 32-bit php_pdo_sqlsrv_71_nts.dll | 7.1 | no | 32-bit php7.dll |
32-bit php_sqlsrv_71_ts.dll 32-bit php_pdo_sqlsrv_71_ts.dll | 7.1 | yes | 32-bit php7ts.dll |
64-bit php_sqlsrv_71_nts.dll 64-bit php_pdo_sqlsrv_71_nts.dll | 7.1 | no | 64-bit php7.dll |
64-bit php_sqlsrv_71_ts.dll 64-bit php_pdo_sqlsrv_71_ts.dll | 7.1 | yes | 64-bit php7ts.dll |
32-bit php_sqlsrv_72_nts.dll 32-bit php_pdo_sqlsrv_72_nts.dll | 7.2 | no | 32-bit php7.dll |
32-bit php_sqlsrv_72_ts.dll 32-bit php_pdo_sqlsrv_72_ts.dll | 7.2 | yes | 32-bit php7ts.dll |
64-bit php_sqlsrv_72_nts.dll 64-bit php_pdo_sqlsrv_72_nts.dll | 7.2 | no | 64-bit php7.dll |
64-bit php_sqlsrv_72_ts.dll 64-bit php_pdo_sqlsrv_72_ts.dll | 7.2 | yes | 64-bit php7ts.dll |
Driver file | PHP version | Thread safe? |
---|---|---|
php_sqlsrv_7_nts.so php_pdo_sqlsrv_7_nts.so | 7.0 | no |
php_sqlsrv_7_ts.so php_pdo_sqlsrv_7_ts.so | 7.0 | yes |
php_sqlsrv_71_nts.so php_pdo_sqlsrv_71_nts.so | 7.1 | no |
php_sqlsrv_71_ts.so php_pdo_sqlsrv_71_ts.so | 7.1 | yes |
php_sqlsrv_72_nts.so php_pdo_sqlsrv_72_nts.so | 7.2 | no |
php_sqlsrv_72_ts.so php_pdo_sqlsrv_72_ts.so | 7.2 | yes |
Driver file | PHP version | Thread safe? | Use with PHP .dll |
---|---|---|---|
32-bit php_sqlsrv_7_nts.dll 32-bit php_pdo_sqlsrv_7_nts.dll | 7.0 | no | 32-bit php7.dll |
32-bit php_sqlsrv_7_ts.dll 32-bit php_pdo_sqlsrv_7_ts.dll | 7.0 | yes | 32-bit php7ts.dll |
64-bit php_sqlsrv_7_nts.dll 64-bit php_pdo_sqlsrv_7_nts.dll | 7.0 | no | 64-bit php7.dll |
64-bit php_sqlsrv_7_ts.dll 64-bit php_pdo_sqlsrv_7_ts.dll | 7.0 | yes | 64-bit php7ts.dll |
32-bit php_sqlsrv_71_nts.dll 32-bit php_pdo_sqlsrv_71_nts.dll | 7.1 | no | 32-bit php7.dll |
32-bit php_sqlsrv_71_ts.dll 32-bit php_pdo_sqlsrv_71_ts.dll | 7.1 | yes | 32-bit php7ts.dll |
64-bit php_sqlsrv_71_nts.dll 64-bit php_pdo_sqlsrv_71_nts.dll | 7.1 | no | 64-bit php7.dll |
64-bit php_sqlsrv_71_ts.dll 64-bit php_pdo_sqlsrv_71_ts.dll | 7.1 | yes | 64-bit php7ts.dll |
Driver file | PHP version | Thread safe? |
---|---|---|
php_sqlsrv_7_nts.so php_pdo_sqlsrv_7_nts.so | 7.0 | no |
php_sqlsrv_7_ts.so php_pdo_sqlsrv_7_ts.so | 7.0 | yes |
php_sqlsrv_71_nts.so php_pdo_sqlsrv_71_nts.so | 7.1 | no |
php_sqlsrv_71_ts.so php_pdo_sqlsrv_71_ts.so | 7.1 | yes |
Driver file | PHP version | Thread safe? | Use with PHP .dll |
---|---|---|---|
php_sqlsrv_7_nts_x86.dll php_pdo_sqlsrv_7_nts_x86.dll | 7.0 | no | 32-bit php7.dll |
php_sqlsrv_7_ts_x86.dll php_pdo_sqlsrv_7_ts_x86.dll | 7.0 | yes | 32-bit php7ts.dll |
php_sqlsrv_7_nts_x64.dll php_pdo_sqlsrv_7_nts_x64.dll | 7.0 | no | 64-bit php7.dll |
php_sqlsrv_7_ts_x64.dll php_pdo_sqlsrv_7_ts_x64.dll | 7.0 | yes | 64-bit php7ts.dll |
Driver file | PHP version | Thread safe? |
---|---|---|
php_sqlsrv_7_nts.so php_pdo_sqlsrv_7_nts.so | 7.0 | no |
php_sqlsrv_7_ts.so php_pdo_sqlsrv_7_ts.so | 7.0 | yes |
Driver file | PHP version | Thread safe? | Use with PHP .dll |
---|---|---|---|
php_sqlsrv_54_nts.dll php_pdo_sqlsrv_54_nts.dll | 5.4 | no | php5.dll |
php_sqlsrv_54_ts.dll php_pdo_sqlsrv_54_ts.dll | 5.4 | yes | php5ts.dll |
php_sqlsrv_55_nts.dll php_pdo_sqlsrv_55_nts.dll | 5.5 | no | php5.dll |
php_sqlsrv_55_ts.dll php_pdo_sqlsrv_55_ts.dll | 5.5 | yes | php5ts.dll |
php_sqlsrv_56_nts.dll php_pdo_sqlsrv_56_nts.dll | 5.6 | no | php5.dll |
php_sqlsrv_56_ts.dll php_pdo_sqlsrv_56_ts.dll | 5.6 | yes | php5ts.dll |
Driver file | PHP version | Thread safe? | Use with PHP .dll |
---|---|---|---|
php_sqlsrv_54_nts.dll php_pdo_sqlsrv_54_nts.dll | 5.4 | no | php5.dll |
php_sqlsrv_54_ts.dll php_pdo_sqlsrv_54_ts.dll | 5.4 | yes | php5ts.dll |
php_sqlsrv_55_nts.dll php_pdo_sqlsrv_55_nts.dll | 5.5 | no | php5.dll |
php_sqlsrv_55_ts.dll php_pdo_sqlsrv_55_ts.dll | 5.5 | yes | php5ts.dll |