Can't view database objects using tools for Visual Studio
722972Sep 16 2009 — edited Jan 18 2011I recently downloaded and installed the Oracle tools for Visual Studio (Oracle 11g ODAC 11.1.0.7.20 with Oracle Developer Tools for Visual Studio). I was able to create a connection to the target database using the ODP.net provider; however, none of the database objects were visible in VS Server Explorer. For example, the tables folder in Server Explorer was empty, as was every other folder in the schema. Changing views from object view to schema view did not make any difference.
I tried the same connection using the Microsoft data provider for Oracle and I experienced the same problem. I could connect, but no data objects were visible. When I checked the change views menu, the options were different. Instead of Object view and schema view, I could select from My Objects, User Objects, and All Objects. My Objects was selected, so I changed it to All objects. After that change, I was able to see the data tables, stored procs, and all of the other data objects that should have been visible in the schema.
What do I need to change to make the data objects visible in Server Explorer using the ODP connection?
Thanks