Can not see database tables
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19839
Printed Date: 20 Apr 2025 at 8:07am
Topic: Can not see database tables
Posted By: lonh
Subject: Can not see database tables
Date Posted: 31 Jul 2013 at 5:01pm
I have a sql express database at work. I copy it to my zip drive and copy it to my laptop which I have sql installed. I can access the database tables going through sql server management. in vb.net I added a CR project to my current project. when I create a connection to sql database I only see dbo, information_schema and sys. anyone know why this is happening.
thanks
-------------
Poppy Lon
|
Replies:
Posted By: lockwelle
Date Posted: 14 Aug 2013 at 4:47am
did you click on dbo? dbo is the default schema, and it 'owns' the tables in it's schema. The schema ownership is a way to enforce security and restrict users from seeing tables/view/stored procs, and/or limiting what they can do to the database.
it's also a way of grouping everything.
it's a bit late for a answer...better than never, and I am sure someone else has/will run into the same issue.
HTH
|
Posted By: lonh
Date Posted: 17 Aug 2013 at 2:59pm
thx its their
-------------
Poppy Lon
|
|