Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Can not see database tables Post Reply Post New Topic
Author Message
lonh
Newbie
Newbie
Avatar

Joined: 08 Jul 2013
Location: United States
Online Status: Offline
Posts: 11
Quote lonh Replybullet Topic: Can not see database tables
    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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
lonh
Newbie
Newbie
Avatar

Joined: 08 Jul 2013
Location: United States
Online Status: Offline
Posts: 11
Quote lonh Replybullet Posted: 17 Aug 2013 at 2:59pm
thx its their
Poppy Lon
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.