FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

On Tue, 18 Sep 2001, Pavel Hlousek wrote:

> 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?

Possibly.  Did you configure PHP with --with-sybase or --with-sybase-ct ?

Brian