We are trying to query data from some tables in Sybase (System 11) running on Solaris.
Our client application consists of SqlDBX, running on Windows Vista, that connects to the Sybase server through ODBC.
The following query returns data:
SELECT * FROM SYSOBJECTS WHERE 1=1
but the following query
SELECT * FROM SYSOBJECTS
fails with this error:
DIAG  [INTERSOLV][ODBC SQL Server driver][SQL Server]Incorrect syntax
near 'FROMsysobjectss'. (102)
Note that in the error message, there is no space between "FROM" and "sysobjects", and there is an extra "s" at the end of "sysobjects".
The above is just an example of the odd behavior we have observed. For other tables, behavior of the query depends on the content of the WHERE clause.
Thanks for your help.