Skip to Main Content

Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't view database objects using tools for Visual Studio

722972Sep 16 2009 — edited Jan 18 2011
I 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
This post has been answered by cganesh-Oracle on Sep 17 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2011
Added on Sep 16 2009
5 comments
5,994 views