sybase error - object name error

[enterume]

I couldn't find out what's the problem with the query to the MSSQL server.

my PHP code is:

 $query = "SELECT count(system_id)  FROM profile";

	$res = sybase_query($query);
	if ($res) {
		while ($_row = sybase_fetch_row($res)) {
			$_rowCount = $_row[0];			
		}
	}
 

The error message is as below:

Warning: sybase_query(): Sybase message: Invalid object name 'profile'. (severity 16)

What's the problem, there is a table name profile. 😕

[drawmack]

sybase != ms_sql. You're using the wrong function.

[enterume]

Originally posted by drawmack
sybase != ms_sql. You're using the wrong function.

I am compile my PHP with freetds. When I use mssql it show function undefied. So i use sybase.

I am able connect to another MSSQL server with sybase_*.

My problem now is, I can connect to the server, but couldn't perform any selection from any tables.

thanks😕