Cannot see the tables for the databse

[madvalpreston]

Hi

I have created a connection to a database in Crystal. In options I have it ticked so it should show tables.

The connection works, but when I go into the data area I have

DBO - Showing no tables (I expect to see the DB tables here)
Information Schema - Information listed below here
SYS - System tables showing here.

Does anyone have any ideas what i can do to get the DBO tables to show... I have tried ticking and unticking everything in the Options for the connection but no luck.

Any ideas please

Thanks

 

[Turkbear]

Hi,
More details please:
What database ?
Where is it - on PC or on a remote server?
Are you sure the user acount has sufficient rights to see table?

Can you connect with that id in some other tool and see the tables?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[madvalpreston]

Hi

The database is SQL server DB
It is on a remote server that I am working on
How do I see if the user as sufficient rights in SQL????


I will test and ODBC link now and get back on that one

Thanks

 

[madvalpreston]

Hi

Due to it being a server it does not have excel for instance loaded so hard to see if it shows tables.

I created an ODBC connection and it connected fine. I tried to apply it to Crystal but could not find any suitable connection to use that could see the ODBC lists.

So a little stuck now,

Please advise if you can further

Thanks

 

[madvalpreston]

Hi

I found under the database security itself and tried some permissions, I finally for the tables to appear.

Thanks for the reply the prompt about permissions pointed me in the right direction,

Thanks