Access MSSQL Server 2000 with PHP - TechRepublic
Question
June 20, 2007 at 01:56 AM
lord_mujahid

Access MSSQL Server 2000 with PHP

by lord_mujahid . Updated 19 years, 1 month ago

i want to work with mssql server 2000 and php.
i want to connect them via mssql functions.
but i have an error which is listed below at the end:

i have done the following steps:
installation of mssql server 2000 and php 5.2.3 with IIS on Windows XP.
then i did few changes in php.ini file

1->uncomment all mssql.—_dll files especially
mssql.allow_persistent=on

2-> then i copied php_mssql.dll to php/ext directory and windows/system32/

3-> i copied ntwdblib in php and windows/system32 directory

after all i write a code to access the mssql database

the code is given below:

\n”;
}
mssql_close($sqlconnect);

?>

and the error is::::::
———————————————

“Error selecting the databasePHP Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: localhost,1433 in C:\Inetpub\wwwroot\php\test.php on line 34 PHP Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:\Inetpub\wwwroot\php\test.php on line 35”

———————————————–

how could solve this problem any idea ??
thanks in advance.
regards

————
maanijanjua

This discussion is locked

All Comments