problem in mssql

ramez_sever

hello.........
please i have Windows XP and IIS4 server
i have Microsoft Sql Server 2000 personal

and i want to connect to database called pubs

i try this but it dosn't work

mssql_connect("localhost","sa","123456");

mssql_select_db("pubs");

it gives me a massege

Fatal error: Call to undefined function: mssql_connect() in c:\inetpub\wwwroot\php\ms.php on line 11

some one say you should uncommite
extension=php_mssql.dll

i try

but it gives me error

Content-type: text/html X-Powered-By: PHP/4.3.0
Fatal error: Call to undefined function: mssql_connect() in c:\inetpub\wwwroot\php\ms.php on line 11

PHP Warning: Unknown(): Unable to load dynamic library './php_mssql.dll' - The specified module could not be found. in Unknown on line 0

this my problem anyone can help me please

timbr8ks

Try this:

$link=mysql_connect ("localhost", "sa", "123456") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("pubs");

Also, I typically make the elements variables. So, it would look like this:

$Host="localhost";
$DBase="pubs";
$User = "sa";
$Password = "12345";

$link = mysql_connect($Host, $User, $Password) or die('Could not connect because' . mysql_error());
mysql_select_db($DBase);

ramez_sever

hi timbr8ks thanks for tring to solve my problem......

$link=mysql_connect ("localhost", "sa", "123456") or die ('I cannot connect to the database because: ' . mysql_error());

but mysql_connect is for MySql Connection
not for Microsoft SqlServer2000 connection........

jerdo

Did you install PHP with the exe or the binary zip?

ramez_sever

the exe installer
why is there differance between them.......

jerdo

Yes there is a difference. Uninstall it and use the binary installation and you should be fine. The executable doesn't include half of the added extensibility that the binary offers.

ramez_sever

how can i install this package........
what is the way to do it.....
i am using Windows XP and IIS server

jerdo

Just download the zip and follow the install file that comes with it. It will take you through step by step. It's pretty painless, I've used the zip for both Apache and IIS, the install file covered them both nicely.