Question Locked

Access MSSQL Server 2000 with PHP

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

This discussion is closed to new replies.