Connecting to SQL via OLE DB shows no Views

[-cush-]

With Crystall XI, when I connect to a SQL Server Database using OLE DB (ADO), I can browse to the database then to the owner, then there is a tree for Tables and Stored Procedures. Usually, ther is also a tree for the views. On this particular databse, there is not! There are views in the database, and I need to access them. Any ideas??

 

[Turkbear]

Hi,
Have you checked that all the options for the connection are enabled..Many have separate check boxes for Table, SPs and Views.

CR also has such an option list under the Database tab I believe.





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

 

[-cush-]

If I set the datasourse location from the "test" databse to the "live" database, then the views show up.