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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't see Views when I connect to SQL Server 7 db

Status
Not open for further replies.

DiggerDog

Programmer
Nov 24, 2002
60
AU
Hi

I connect to my SQL Server 7 db using an odbc connection but I can't see my list of bd views - I can see the tables and stored procedures. I have checked Allow reporting on views. Any help appereciated
 
Before you dive into the permisions of the db, look at the settings for the report options under File - Options - Database to ensure that the views box is checked. If it is, and you can't see your views, then check the db permissions. If it is not checked, put a check in the box and create a new report to use the new option. Rod Oatis
Venturi Technology Partners
Crystal Decisions Certified
Trainer/Consultant/Developer/Implementor
Rod_Oatis@hotmail.com
 
Sorry about that. I had a BSOD on the brain. Rod Oatis
Venturi Technology Partners
Crystal Decisions Certified
Trainer/Consultant/Developer/Implementor
Rod_Oatis@hotmail.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top