FreeTDS Development Group

["Pavel Hlousek" <hlousek AT excon.cz>]

Hi,

I'm using MSSQL 7.0 on WinNT4.0, FreeTDS 0.51 with tdsver=4.2, client is
SuSe Linux 7.1, Apache 1.3.19, PHP 4.0.6.

I've run into troubles while checking SELECT permissions for several
tables within a single db connection. In a typical case, I think, this
should work fine:

##################################################
$php_errormsg = '';
@mssql_query("SELECT * FROM $table");
if (!empty($php_errormsg)) {
   echo "It seems you cannot access table $table";
}
##################################################

But this code works only the first time within a single connection to
MSSQL server. The 2nd call to such a code does nothing with the contents
of $php_errormsg, even when there should be message 'Permission denied'.
(Sometimes the next call to mssql_query without '@' fires the exception.)

I've also tried a piece of code like this, but the result was the same:

##################################################
$php_errormsg = '';
$result = mssql_query("SELECT * FROM $table");
if (! $result) {
   echo "It seems you cannot access table $table";
}
##################################################

It seems to me, that there is a bug somewhere. Any help?