Error while connecting with SQL Server

[indiavitus]

Hi,

I am not able to connect to SQLServer database hosted on some other machine.
I am using the following code to do this:

<?php
$myServer = "192.168.0.13";
$myUser = "sa";
$myPass = "test123";
$myDB = "Test_DBSchema";

//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
or die("Couldn't connect to SQL Server on $myServer");

//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
or die("Couldn't open database $myDB");

//declare the SQL statement that will query the database
$query = "SELECT count(*) from test";
//Name, Address, City

//execute the SQL query and return records
$result = mssql_query($query);

$numRows = mssql_num_rows($result);
echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>";

//display the results
while($row = mssql_fetch_array($result))
{
echo "<li>" . $row["id"] . $row["name"] . $row["year"] . "</li>";
}
//close the connection
mssql_close($dbhandle);
?>


Please suggest me.

Thanks,
Manoj Singh

[egami]

Any errors ?
Timeouts?

Hard to help, with out any debugging!

[boybawang]

if you are encountering this problem with the code your using then it may have something to do with the server. Try other options or you may just contact some professional service for your database.