MS SQL connection with PHP fatal error

This question already has an answer here:

  • Call to undefined function mssql_connect()

    1 answer

  • Update table with random record in update statment in SQL Server?
  • Skip columns in BIML SSIS Script
  • SQL Server - script to update database columns from varchar to nvarchar if not already nvarchar
  • Invalid object name 'dbo.TableName' when retrieving data from generated table
  • how to display the column which is used to join the table
  • SQL massive performance difference using SELECT TOP x even when x is much higher than selected rows
  • 2 Solutions collect form web for “MS SQL connection with PHP fatal error”

    The MSSQL extension is not activated by default.

    • Do a phpinfo() to find out which php.ini file is used by your PHP installation

    • open that php.ini file

    • uncomment the line saying ;extension=php_mssql.dll (remove the semicolon)

    • Restart the server if necessary

    “mssql” was dropped from PHP 5.3 distribution. Use sqlsrv drivers instead. You can find those at this link PHP drivers for MS-SQL

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.