MS SQL Server Concepts and Programming Question:

Download Questions PDF

Answer #1
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.

Answer #2
; Directory in which the loadable extensions (modules)...
; extension_dir = "./"
extension_dir = "./ext"

Run the script again, you may still errors. But it is not related to MSSQL API Module any more.

Warning: mssql_connect(): Unable to connect to server:
LOCALHOST in C: estglobalguideline.php on line 2