PHP mssql

pang

hi
I'm trying to make a connection to a Microsoft SQL Server database in SAHARA Server.I have no problem when i use ODBC functions. But when i want to use mssql functions i get just a blank page.
i've already configured php.ini by activating the line
extension=php?_mssql.dll and i have php_mssql in both /WWINNT/system32 and /extension.

In Microsoft SQL utilities i've take sihamsahara as an alias of SAHARA and i've choose TCP/IP protocole and give the port 1433.
Here is my code

$server="sihamsahara";
$username="siham";
$password="siham";
$sqlconnect=mssql_connect($server,$username,$password);
$sqldb=mssql_select_db("Equivalence_2005",$sqlconnect);
$sqlquery="SELECT nom_ville FROM Ville";
$results=mssql_query($sqlquery);
$lastMsg = mssql_get_last_message();
echo $lastMsg;
while($row=mssql_fetch_array($results)){
echo $row['nom_ville']."<br>\n";}
mssql_close($sqlconnect);

can anyone help me

hthighway

You might try adding the port number to the servername

$server="sihamsahara:1433";

As well as adding an "or die" statement to the connect command. This way you will see if if stops on this command.

$sqlconnect=mssql_connect($server,$username,$password) or die ("<strong>ERROR: Connection  failed</strong>");

pang

i steal get a blank page even when i added the port and the die statement, i think there is somthing in the configuration, but i don't know where it is...

$server="sihamsahara:1433";
$username="siham";
$username="siham";
$sqlconnect=mssql_connect($server,$username,$password) or die ("<strong>ERROR: Connection  failed</strong>");;
$sqldb=mssql_select_db("Equivalence_2005",$sqlconnect);
$sqlquery="SELECT ville FROM Ville";
$results=mssql_query($sqlquery);
while($row=mssql_fetch_array($results)){
echo $row['ville']."<br>\n";}
mssql_close($sqlconnect);

:queasy:

chucklarge

well you have $username defined twice, but i see in your original post that you had $password, maybe that is your mistake.
Also, you have double semi-colons at the end of you $sqlconnect statement.

pang

sorry, the original code is right with username defined one time and the semicolon had no influence bcause it is a string

pang

hi
the port is already specified in the alias but i get something new,
i've just execute this code and i've get an error connection:


$server="sihamsahara";
$username="siham";
$username="siham";
$sqlconnect=mssql_connect($server,$username,$password) or die ("<strong>ERROR: Connection  failed</strong>");;
$sqldb=mssql_select_db("Equivalence_2005",$sqlconnect);
$sqlquery="SELECT ville FROM Ville";
$results=mssql_query($sqlquery);
while($row=mssql_fetch_array($results)){
echo $row['ville']."<br>\n";}
mssql_close($sqlconnect);

the message was:ERROR: Connection failed

pang

excuse me but i've tried this and i steal get a blank page : "sihamsahara " is an alias of the servername "SAHARA" situated in a distant machine and the port is 1433.

$server="sihamsahara";
$username="siham";
$password="siham";
$sqlconnect=mssql_connect($server,$username,$password) or die ("<strong>ERROR: Connection  failed</strong>");;
$sqldb=mssql_select_db("Equivalence_2005",$sqlconnect);
$sqlquery="SELECT ville FROM Ville";
$results=mssql_query($sqlquery);
while($row=mssql_fetch_array($results)){
echo $row['ville']."<br>\n";}
mssql_close($sqlconnect);

if i do $server="sihamsahara:1433" i get an ERROR connection, which is normal

pang

the mssql work now.thanks a lot