That did it!!! I must admit that maybe because I am from a visual studio or
windows background I have never had to "Select Schema" like I do with
Cayenne and so I had to idea what to pick 3-4 weeks ago when I first tried
Cayenne. When you connect from visual studio you just give the url and
username and password, there is no schema to select from. Also, when I
wrote the small jdbc program to check my connection it did not ask me for a
schema. What does the schema do?
When I first tried this 3-4 weeks ago I started at the top with
"db_accessadmin" and worked my way down through the 13 options to "db_owner"
and gave up. There were still 5 choices left but I figured that if
"db_owner" did not have the proper rights then none of the others would. I
went into SQL Server and made sure that "db_owner" was assigned full rights
before I gave up. Turns out if I pick "sys" I get a Map with all the tables
including the system tables and if I pick "dbo" I get all the non system
tables. Any idea why "dbo" works but "db_owner" does not? My knowledge of
databases is not extensive so I must admit I do not know much about how the
schemas work in SQL Server.
Sorry if this was a dumb error and wasting everyones time. Thanks for
sticking it out with me!!!
Mark
On Wed, Nov 10, 2010 at 2:22 PM, bogdan_voloshincu <
bogdan_voloshinc..ahoo.com> wrote:
>
> take a look :
>
> http://cayenne.195.n3.nabble.com/Help-cdbimport-Oracle-td1876015.html#a1876015
> --
> View this message in context:
> http://cayenne.195.n3.nabble.com/Reengineer-Database-Schema-not-generating-anything-tp1831261p1878441.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.
>
This archive was generated by hypermail 2.0.0 : Thu Nov 11 2010 - 16:42:21 UTC