How do I get the SQLSRV extension to work with PHP, since MSSQL is deprecated?

by

Quoting http://php.net/manual/en/intro.mssql.php:

The MSSQL extension is not available anymore on Windows with PHP 5.3 or later.
SQLSRV, an alternative driver for MS SQL is available from Microsoft: ยป http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx.

Once you downloaded that, follow the instructions at this page:

In a nutshell:

Put the driver file in your PHP extension directory.
Modify the php.ini file to include the driver. For example: 

extension=php_sqlsrv_53_nts_vc9.dll

Restart the Web server.

See Also (copied from that page)

The PHP Manual for the SQLSRV extension is located at http://php.net/manual/en/sqlsrv.installation.php and offers the following for Installation:

The SQLSRV extension is enabled by adding appropriate DLL file to your PHP extension directory and the corresponding entry to the php.ini file. The SQLSRV download comes with several driver files. Which driver file you use will depend on 3 factors: the PHP version you are using, whether you are using thread-safe or non-thread-safe PHP, and whether your PHP installation was compiled with the VC6 or VC9 compiler. For example, if you are running PHP 5.3, you are using non-thread-safe PHP, and your PHP installation was compiled with the VC9 compiler, you should use the php_sqlsrv_53_nts_vc9.dll file. (You should use a non-thread-safe version compiled with the VC9 compiler if you are using IIS as your web server). If you are running PHP 5.2, you are using thread-safe PHP, and your PHP installation was compiled with the VC6 compiler, you should use the php_sqlsrv_52_ts_vc6.dll file.

The drivers can also be used with PDO.

More Related Contents:

  1. How to escape strings in SQL Server using PHP?
  2. PHP Fatal error: Call to undefined function mssql_connect()
  3. Connect PHP to MSSQL via PDO ODBC
  4. How can I detect a create, update, delete query is successful in Codeigniter
  5. Connect to SQL Server through PDO using SQL Server Driver
  6. Notice: Array to string conversion in
  7. Should a MAMP return ::1 as IP on localhost?
  8. PHP Install SSH2 on Windows machine
  9. How to connect to mssql using pdo through PHP and Linux?
  10. How to get Insert id in MSSQL in PHP?
  11. How to execute Stored Procedure from Laravel
  12. Getting data with UTF-8 charset from MSSQL server using PHP FreeTDS extension
  13. PHP Startup Unable to load dynamic library php_mongo.dll
  14. CodeIgniter MSSQL connection
  15. How to connect sql server with php using xampp?
  16. PHP + SQL Server – How to set charset for connection?
  17. “Adaptive Server is unavailable or does not exist” error connecting to SQL Server from PHP
  18. Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs
  19. How to use PHP to connect to sql server
  20. How to fix PHP Warning: PHP Startup: Unable to load dynamic library ‘ext\\php_curl.dll’?
  21. Linux – PHP 7.0 and MSSQL (Microsoft SQL)
  22. json_encode produce JSON_ERROR_UTF8 from MSSQL-SELECT
  23. SQL Server error 1934 occurs on INSERT to table with computed column PHP/PDO
  24. Get Return Value from SQL Stored Procedure using PHP
  25. Guzzlehttp – How get the body of a response from Guzzle 6?
  26. How do I install cURL on Windows?
  27. PHP OOP core framework
  28. Remove .php extension with PHP
  29. Fatal error: Call to undefined method mysqli_result::fetch_all()
  30. Cannot figure out how to run a mysqli_multi_query and use the results from the last query

Leave a Comment