ODBC to SQL Server shows list of procedures but not list of tables or views

Question

In VS 2008, VB.Net, I am successful connecting to a local SQL Server and seeing all tables/views/procedures. I created an ODBC data source to a remote SQL server with a database of the same structure as the local one. The connection tests out ok. In the VS 2008 Server Explorer I add this source. When I click on the plus-signs to expand items, neither the tables nor the views show anything, whereas the full list of procedures appears. How can I see the lists of tables and views in Server Explorer for an ODBC source?

Answer 1

Hi Robertrackl,

Welcome to MSDN forums!

"In VS 2008, VB.Net, I am successful connecting to a local SQL Server and seeing all tables/views/procedures."
-> As for the local SQL Server, did you still use ODBC Data Source to connect to it?

Here are some threads discussing the similar issue to yours, please check them for reference.
http://www.dotnetmonster.com/Uwe/Forum.aspx/vs-net-general/8146/How-to-List-a-table-in-Tables-holder-of-Server-Explorer
https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=123248

Walkthrough: Create Connecion to an ODBC Data Source in Server Explorer

http://msdn.microsoft.com/en-us/library/aa984313(VS.71).aspx

You also can consoder posting it at ADO.NET Data Providers forum for better responses.


Best regards,
Martin Xie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.