VS 2010 Server Explorer Database Showing No Tables

Question

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 1

Do you have privileges on the schema and/or tables?

Don't know VS2010 but it sounds to me like there's a setting to show you only your schema by default.

UPDATE: Oracle just announced a new ODAC version, 11.2.0.1.1 Beta with support for VS 2010. You might give that a shot.

Answer 2

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.

Answer 3

I have VS 2008 and ODT ODAC 11.2.0.1.2. Under "Change View", I only have "Objects" (default) and "Schemas". With "Objects" View, I see all Object Types but no instances except my User ID under "Users" and some / all "Roles". With "Schemas" View, "Users" disappears and everything except "Roles" gets moved under a new "Schemas->(User Name)" tree item, but still no other objects show. I've tried checking the "Disable filter" box on the Filters for all Objects. Just for grins, I also tried filtering on Table Name "is not" "x" and also tried restricting the Visible Collections to just Tables.

From either view, I'm able to execute a Select Query from the Server Explorer from at least one of the suppressed Tables. I'm also able to access the Table from code via either "System.Data.OracleClient" or "Oracle.DataAccess.Client" as well as from SQL Plus or SQL Plus Worksheet.

When adding the Connection, if I change the Data Source from "Oracle Data Provider for .NET" to ".NET Framework Provider for OLE DB", I can see all objects (although I still can't change their Properties probably because I don't have rights). With the "Oracle Data Provider", I get an Oracle-specific Query editor with extra analysis. transaction options in addition to the generic MS Query Designer.