Hello,

I'm having a lot of difficulty querying a database. So a little
background first. I setup an ODBC connection to the database using the
default guest login that allows read-only access. I can see the
tables, column names, and even the data just fine in the Sybase
Central client.

However when I run a simple select statement in the iSQL client:

select id from action_log

I get the error message:

Table 'action_log' not found
SQLCODE=-141, ODBC 3 State="42S02"

Keep in mind that I can view the same tables and column names (but not
data) in the iSQL client. Any idea what the issue is here? I've tried
other querying other tables but the results are the same. If it makes
any difference, the DB I'm connecting to is used for the Veritas
Backup Report tool. It's a Symantec product and all the credentials
and connection information was provided by the admin guide.

Thanks,
Carter

probably you have to prefix the owner of the table.

select * from <owner>.<table>

HTH

On Mar 22, 12:53*pm, tduemesnil <tduemes... (AT) googlemail (DOT) com> wrote:
BINGO. thanks a LOT.

On Mar 22, 12:53*pm, tduemesnil <tduemes... (AT) googlemail (DOT) com> wrote:
BINGO. thanks a LOT.