I work on a sybase 11.9.2 and have to generate a few Reports,
that are missing in Intershop.

I can connect to the server as 'sa'. All I can see are the
system-tables.
With the Browser 'Sybase Central' I can verify that the table
'customer' exists. It was created by dbo and the user InterShopOnline
has the right to select this table.

Now I've tried to select like
select * from customer
select * from dbo.customer
select * from InterShopOnline.customer

But the Server says: customer not found. Specify owner.objectname
or use sp_help to check whether the object exists.
I did that. sp_help lists just the system-tables.

What's the trick to get the user-tables?
please help.

On Mon, 20 Sep 2004 08:22:25 -0700, xs65 wrote:

You need to "use" the appropriate user database.

Right now when you log in as "sa" you're in the "master" database, which
should have no user tables.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html