VS 2010 Server Explorer Database Showing No Tables

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.

Right click on connections, go to Filters, the "displayed schemas" property by default, it's your logon name to the connection. Change the schemas to dbo schema and update the property. Then you should see all the tables. It worked for me :)

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.