Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to view all database tables when connected to server

Status
Not open for further replies.

SmileyFace

Programmer
Sep 10, 2002
99
US
Could someone please tell me why I cannot view all tables in my database even after refreshing the connection in my report? HELP!
Here are the properties of my database file:

Server Type=Microsoft SQL Server
Server Name=USCTDB01
Database=OMS
User ID=ReportUser
Database DLL Name=pdssql.dll
Server Type=Microsoft SQL Server
Datasource Type=SQL

Even the existant report I have won't let me view the tables it accesses inside the OMS database. I need to create another report to access another table in the same database but everytime I refresh the connection it still won't work!!! I cannot see all tables inside the database named OMS. Please tell me what to do! Thanks for any help offered!
 
Probably permissions.

Check who the owner is for the tables, and whether you have permission to use them.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top