VS 2010 Browser Database with No Tables

Question

I am working on a .Net application that needs to be read from an Oracle 10g database for Siebel. In VS Server Server Explorer, I created a connection using an OracleClient type connector with a reference to the Oracle TNS service name as the "server name". The “Test Connection” button indicates that the connection was successful. However, in Server Explorer, when I switch to expanding tables, tables are not displayed. I know that there are 3000+ tables in the database (thanks Siebel). Does anyone know what is going on here? I would like to create an Entity Framework 4.0 Entity Data Model ...

Thanks for the help!

Andy

Answer 1

It was the hardest thing for me to solve this problem myself. There is very little useful documentation on this subject. After you have created a data connection and tested the connection, click OK, then open the server browser window. Right-click the new Oracle data connection and select Change View. My Objects is selected by default, try selecting Custom Objects or All Objects. After that, you can see all the objects in the subcategories of data connection.

Answer 2

Right-click on connections, go to "Filters", the default "displayed schemas" property is your login to the connection. Change the schemas to the dbo schema and update the property. Then you should see all the tables. It worked for me :)

Answer 3

Do you have rights to the schema and / or tables?

I don’t know VS2010, but it seems to me that there is a setting showing only your default circuit.

UPDATE: Oracle has just announced a new version of ODAC, 11.2.0.1.1 Beta with support for VS 2010. You can specify that shot.

Answer 4

The same situation happened for me, however, it was with SQL Server 2008. Somehow, with the sql user account that I contacted, the read and write rights were lost. After the account returned these privileges, I was able to access all as expected.