VS 2010 Server Explorer 数据库不显示表
我正在开发一个 .Net 应用程序，该应用程序需要从 Siebel 后面的 Oracle 10g 数据库中读取数据。在 VS 2010 Server Explorer 中，我使用 OracleClient 类型连接器创建了一个连接，并引用 Oracle TNS 服务名称作为“服务器名称”。 “测试连接”按钮显示连接成功。但是，在服务器资源管理器中，当我展开表时，没有显示任何表。我知道数据库中有 3000 多个表（感谢 Siebel）。有人知道这里发生了什么事吗？我想创建一个 Entity Framework 4.0 实体数据模型...
感谢您的帮助！
安迪
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
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我在尝试自己解决这个问题时经历了最困难的时期。关于这个主题的有用文档非常少。创建数据连接并测试连接后，单击“确定”，然后打开服务器资源管理器窗口。右键单击新的 oracle 数据连接并选择“更改视图”。默认情况下选择“我的对象”，尝试选择“用户对象”或“所有对象”。完成后，您应该能够看到数据连接子类别下的所有对象。
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.
右键单击连接，转到过滤器，默认情况下是“显示的架构”属性，它是您连接的登录名。将架构更改为 dbo 架构并更新属性。然后你应该看到所有的表。它对我有用:)
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 :)
您对架构和/或表有权限吗？
不了解 VS2010，但在我看来，有一个设置默认情况下仅显示您的架构。
更新：Oracle 刚刚宣布了一个新的 ODAC 版本，11.2.0.1.1 Beta，支持 VS 2010。您可以尝试一下。
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.
我也遇到了同样的情况，但是这是在 SQL Server 2008 中发生的。不知何故，我连接的 sql 用户帐户失去了读取和写入权限。一旦帐户被归还这些权限，我就可以按预期访问所有内容。
The same situation occurred for me, however this was with SQL Server 2008. Somehow the sql user account I was connecting with lost both read and write privileges. Once the account was given back those privileges I was able to access everything as expected.