Answers

Question and Answer:

  Home  MS SQL Server

⟩ How to Turn on the MSSQL API Module in PHP?

If you want to access SQL Server database with PHP scripts, the first thing you need to do is to turn on the MSSQL API Module as shown in this tutorial:

1. Prepare a single line script to test the MSSQL API Module:

<?php

mssql_connect('LOCALHOST','sa','GlobalGuideLine');

?>

Run the script, you should get:

Fatal error: Call to undefined function mssql_connect()

in C: estglobalguideline.php on line 2

2. If you C:phpphp.ini does not exist, copy C:phpphp.ini-dist to C:phpphp.ini. Open C:phpphp.ini and remove (;) on the extension=php_mssql.dll setting:

;extension=php_mssql.dll

extension=php_mssql.dll

Run the script again, you may get:

PHP Warning: PHP Startup: Unable to load dynamic library

'C:php5php_mssql.dll' - The specified module could not

be found.

in Unknown on line 0

Fatal error: Call to undefined function mssql_connect()

in C: estglobalguideline.php on line 2

3. Open C:>phpphp.ini and change the extension_dir setting. The default setting is "./", but all extension module DLL files are in ./ext.

 151 views

More Questions for you: