Anyone see a problem with this script??

[medar]

This is a small script that should connect to a remote MSSQL database (a buddy of mine and I are trying this). I have worked on this for two evenings now...to no avail.

<?php

$hostname = "65.16.54.15";
$username = "User";
$password = "Pass";
$dbName = "DBName";

MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND.");
mssql_select_db($dbName) or DIE("Table unavailable");

$query = "SELECT * FROM Players";

$result = MSSQL_QUERY($query);

$number = MSSQL_NUM_ROWS($result);

$i=0;

if ($number == 0) :
print "No data?";
elseif ($number > 0) :
print "Data:";
while ($i < $number) :
$name = mssql_result($result,$i,"Name");
print $name;
print "";
$i++;
endwhile;
endif;
?>

This is the output I receive:

Fatal error: Call to undefined function: mssql_connect() in /www/url/test2.php on line 8

Thanks for any help you can offer.

[Anon]

Though it may not matter, you might try typing your function in lowercase letters. MSSQL_CONNECT becomes mssql_connect.

[rrijnders]

Is your php installation on a Windoze box or on a nix box? My guess is that you are trying to run this script on a nix box since you are trying to access a remote SQL Server installation.

You can't do that using mssql_ functions. You will have to sybase extensions; wich means that you have to make sure that your installation has sybase support compiled in.

see:
http://www.php.net/manual/en/ref.mssql.php

for more info.

-- Rich

[Anon]

are you developing on windows? have you enabled the mssql extension as described in http://www.php.net/manual/en/ref.mssql.php ?

[Anon]

Rich - Fonzi...

You guys are correct, and I completely overlooked that.

I am running this on a *nix box using my good ole worked-for-everything-so-far PHP installation. I doubt sybase support is installed.

I am trying to access a remote MSSQL database hosted on a Windoze server.

Thanks for the help guys...going to look for workarounds now. I am too used to using MySQL!