What you describe now sounds about right. Not sure why it works like that (I am not a SQLServer admin, and don't use it for anything real), but "dbo" being a user default schema in SQLServer rings a bell to me. Glad you found a solution. I ran out of ideas of why that might be failing.
Andrus On Nov 11, 2010, at 11:41 AM, Mark Fischer wrote: > 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 < > [email protected]> 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. >>
