Couldn't open database using MSSQL DB

[osusano]

i am newbie using MSSQL as a DB Server i need to connect but i dont know why it couldnt give me the exact connection.

$myServer = "123.456.789.123";
$myUser = "test";
$myPass = "test";
$myDB = "DBNAME";
$connect = @mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer");
$db = @mssql_select_db($myDB, $connect) or die("Couldn't open database $myDB");

i tried using that kind of script connection and use the DB it always give me an error.

do i have to define the port of the DB?
is there's any problem with my script?

by the way the DB server is not located on my hosting server coz they are the 1 hosting their own DB so what do u think should i do to connect and process my entries on myside?

please help me with this 🙁

ps:
i dont configure the MSSQL on my server do i need to setup up or should i recompile my php?

on my side the sybase_ct is on and even the DBX

so if i need to recompile my server what should i do and where can i find a tutorial on how to configure the connection to MSSQL server

thank you in advance

[noimad1]

Try this code instead:

$servername = "123.456.789.123";
$dbusername = "test";
$dbpassword= "test";

$dbh=mysql_connect ($servername, $dbusername, $dbpassword);

$query = "SELECT * FROM tablename where whatever = 'whatever'";
 $result = mysql_db_query ($dbname,$query);
if($result == false){
echo mysql_errno().":".mysql_error()."<BR>";
exit;
}

and if this script is being run on the same server as the database, then your server can just be "localhost" and does not have to be the IP address.

[noimad1]

actually, sorry I didn't notice you said MSSQL.....that code may not work....