Using Oracle 10g Express and dotConnect 5.00, I am unable to create an Entity Data Model for the Northwind database. Using the VS EDM Wizard, a "Test Connection" on the following connection string is successful:
"user id=northwindef;password=**********;server=XE", but when I get to the "Choose Your Database Objects" dialog, the listing of tables is very long and not at all familiar to me (DR$CLASS (CTXSYS), etc.). There are no tables from Northwind, but I can see the Northwind database and tables in Toad and even in the Visual Studio Server Explorer.
(I am very new to Oracle, but I have some expereince using EF with SQL Server.)
Anyone know what I am doing wrong?
EMD Wizard not showing my tables (newbie question)
Solution
The problem went away when I removed dba privileges from the northwind user. Not sure why this should matter. I had wrongly assumed that granting privileges liberally -- though not necessary or even advisable in the 'real' world -- would remove any potential security issues while I played around. Not.
EDM Wizard
Thank you for the clarification. Since the user had ALL permissions, why didn't I see any of the Northwind tables?