VS 2010 Server Explorer Database Showing No Tables

visual-studio oracle entity-framework server-explorer
Andy picture Andy · Apr 30, 2010 · Viewed 9.6k times · Source

I'm working on a .Net application that needs to read from an Oracle 10g database behind Siebel. In VS 2010 Server Explorer, I've created a connection using the OracleClient type connector with a reference to the Oracle TNS service name as the "server name." The "Test Connection" button shows that the connection is successful. However, in the Server Explorer, when I go to expand the Tables, no tables are shown. I know for a fact that there are 3000+ tables in the database (thanks Siebel). Anyone know what's happening here? I'd like to create an Entity Framework 4.0 Entity Data Model...

Thanks for the help!

Andy

Answer

Steve G. picture Steve G. · May 27, 2010

I've had the hardest time trying to solve this issue myself. There's very little useful documentation on the subject. Once you create a data connection and tested the connection click "Ok" then open up the server explorer window. Right click on the new oracle data connection and select "Change View". By default "My Objects" are selected, try selecting "User Objects" or "All Objects". Once you do, you should be able to see all of the objects under the data connection sub categories.

oracle connection

Related questions

Your project references the latest version of Entity Framework... - Error

I trying to create an entity data model with Oracle. I am getting this error. I have these installed for my solution. I have also installed ODT for VS 2015. These are my references showing. Web.config <configSections> <…

Read More
Managed ODP.NET driver does not show up in Data Source dialog

Having installed managed ODP.NET on my computer, the ODP.NET Managed Driver does not appear inside the Choose Data Source dialog in Visual Studio 2013 Professional. This is how it should look like: This is how it actually looks on …

Read More
C# NHibernate & Oracle Managed Client

I have a big project that conceals another 16 project (Tests, Webs & App like Core, Email etc:.). I use C# MVC4 for my main website project. If I use a non Managed Client need me to do a project folder /…

Read More