php - mssql 2005

[joze]

Hi, i using mssql 2005 and am having big problems with php connect to mssql server.

When i wrote sample script like that:

<?php 

mssql_connect("localhost", "id", "pw") or die('error');

?>

Then i get next error:


Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: localhost in C:\www\reg\test.php on line 3
Could not select the database1

I tried almost evrything ... creater a lot logins allowed remote connections but nothinh help. Btw php is running on the same server as mssql 2005.

Thanks for help.

[MentaL]

[Ace-SG1-]

try take out "or die('error')"

[joze]

then i get just:

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: localhost in C:\www\reg\test.php on line 3

[joze]

Nobody know what else can be wrong?

[KoD]

here also guys

[Bloodfreak913]

if (ALLOW_OPEN != 1){
exit("<strong>Error: </strong>Leave NuB ;]");
}
$connect = mssql_connect("localhost","ID","PW");

[killeraxe13]

try this with selecting database because you said it gives error "Could not select the database1", either connect to kal_auth or kal_db.

$msconnect = mssql_connect("localhost", "user", "pass");
$msdb = mssql_select_db("kal_auth", $msconnect); 

If this doesnt work you can try to connect without user/pass;

$msconnect = mssql_connect("localhost"); 
$msdb = mssql_select_db("kal_auth", $msconnect); 

[KoD]

still not workin