Problem Conneting with MS SQL !

[php_student2]

I have PHP4 & windows 2000 prof.

I edited the php.ini file, so php can excute the php_mssql.dll.

every thing is ok just that, when I tried to connect to MS Sql using the command

mssql_connect("localhost",$USERNAME,$PASSWORD);

I got this message:

Warning: MS SQL: Unable to connect to server: ahmed in d:\inetpub\wwwroot\insert.php on line 5

what is the problem !!??

please Help.

[BluntedbyNature]

post your code. so we can tell you.

[php_student2]

<?
//odbc_connect("","","");

$db = mssql_connect("ahmed","administrator","rsasy");

/*
mssql_select_db("MyDatabase1",$db);

$sql = "insert into Widgets values('wwww',1.5,0)";
mssql_query($sql);
*/
echo "DONE";

?>

[php_student2]

plzzzzzzzzzzzzzzzzzzz help 🙁 !!

[darfbobo]

I'm having the same EXACT problem... 🙁

The weird thing is, when I check the router logs - it doesn't show any access via port 1433 - but I can Telnet into the server on that port and it works fine (and shows up on the router logs as well). It's almost like it's not even accessing the server at all.

If I find the solution, I'll let you know too.

~Brian

[jerdo]

php student, try using localhost or the ip of your machine in place of ahmed in your connect statement.

[php_student2]

ok jerdo, I try to do as you told me.

Thank you darfbobo 🙂.

If it's working with me I'll tell you.