SQL Server Developer Center >
SQL Server Forums
>
SQL Server Tools General
>
ODBC Connectivity to SQL Server 2000 tables using Visual Studio 2008
ODBC Connectivity to SQL Server 2000 tables using Visual Studio 2008
- When I create a connection to my ODBC, I can see Stored Procedures, but tables and views that exist in the same location do not show up in the Server Explorer window.
Can someone tell me why this might happen?- Moved byStoyko Kostov - MSFT Friday, October 23, 2009 4:46 PMSeems like SQL Server Tools is the closest forum to explain server object enumeration performed in Visual Studio 2008 (From:SQL Server Data Access)
Answers
- Finally figured it out. Was using the wrong communication path. We were trying to use SQL SERVER, when we needed to use OLEDB. Just took a while to figure it out.
Thanks for responding!- Marked As Answer bySQLUSAAnswererFriday, November 13, 2009 4:08 PM
All Replies
- Can you explain more?
Could it be permissions?
Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com - Finally figured it out. Was using the wrong communication path. We were trying to use SQL SERVER, when we needed to use OLEDB. Just took a while to figure it out.
Thanks for responding!- Marked As Answer bySQLUSAAnswererFriday, November 13, 2009 4:08 PM
