Can't connect through PHP half of the time

[ejaboneta]

We have an on site mssql database that I'm connecting to from a virtual dedicated server with php. Half of the time it works and then suddenly it stops working. I get the 'Could not connect to server.' from my code below. After an hour or two it decides to work again without any explaination. Any ideas?

 

$mhost = '55.55.555.55:1397';
$muser = 'username';
$mpass = 'password';


$link = mssql_connect($mhost, $muser, $mpass);
if (!$link) {
    die('Could not connect to server.');
}
$db = mssql_select_db('DatabaseName') or die('Could not select db.');

[Brian Swan]

You should be able to get more detailed error information...can you get the error code and the more detailed error message? That will hep in figuring out what is going on.

And, are you running PHP on a Windows machine?

 

Thanks.

 

-Brian