Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs

by

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://www.microsoft.com/en-us/download/details.aspx?id=20098

Step by Step

  1. Download SQLSRV32.EXE (Microsoft Drivers for PHP for SQL Server) from: http://www.microsoft.com/en-us/download/details.aspx?id=20098

  2. Choose path: C:\xampp\php\ext

enter image description here

  1. Uncomment or Append extension = php_sqlsrv_56_ts.dll in php.ini

  2. Restart Apache from XAMPP Control Panel (Stop/Start)

I tested it and it works 100%

You can find the most recent compiled binaries in the official Microsoft Git repository.

More Related Contents:

  1. CodeIgniter MSSQL connection
  2. How to connect sql server with php using xampp?
  3. How to use PHP to connect to sql server
  4. Get Return Value from SQL Stored Procedure using PHP
  5. check if link “still” exists [duplicate]
  6. How to configure XAMPP to send mail from localhost?
  7. What is parameterized query?
  8. Getting raw SQL query string from PDO prepared statements
  9. Reset identity seed after deleting records in SQL Server
  10. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  11. MySQL Prepared statements with a variable size variable list
  12. Make XAMPP / Apache serve file outside of htdocs folder [closed]
  13. Where does PHP’s error log reside in XAMPP?
  14. How to replace MySQL functions with PDO?
  15. Connect to SQL Server through PDO using SQL Server Driver
  16. CakePHP find method with JOIN
  17. “Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP
  18. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  19. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  20. How to avoid code repetition with PHP SQL prepared statements?
  21. Apache is not running from XAMPP Control Panel ( Error: Apache shutdown unexpectedly. This may be due to a blocked port)
  22. “Adaptive Server is unavailable or does not exist” error connecting to SQL Server from PHP
  23. Install FFMPEG on XAMPP
  24. how to configuring a xampp web server for different root directory
  25. Log the actual SQL query using ActiveRecord with Yii2?
  26. How to check if a value already exists to avoid duplicates?
  27. MYSQL select a piece of a string and order by that piece
  28. using mod_rewrite with XAMPP and windows 7 – 64 bit?
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment