B
Bob Day
Using Windows XP Pro, VS 2003, SQL MSDE 2000 Release A
I am installing a VS 2003 on a different computer, and runninng into some
problems with Server Explorer.
It you go to the bottom of Server Explorer to SQL Servers, the
computer/instance name is listed correctly, all tables and info are correct
and accessible. You can display data, design a table, etc. The problem is
with Adding a Conneciton.
In Server Explorer, when you Add A Connection, in the Data Link Properties
Dialog ...
1) Providers tab, the only provide i can find for SQL is "Microsoft OLE DB
Provider for SQL". I thought their was a native (not OLE DB) provide for
SQL 2000, but I don't see how to add it to the list. I have Imports
System.Data.SqlClient in the Solution Property Page, but that doesn't change
anything. How do I add the correct SQL provider (non OLE DB) ?
2) Connections Tab, "Select or enter a SQL Server Name", there is nothing
listed in the drop down arrow for a running the MSDE Release A instance.
You must mannually type in the computer name\instance name. This seems
non-intuitive to me. At least, it would seem, it would show you available
server instances.
I know there is a bug in Service Manager where it doesn't show the servers
correctly (http://support.microsoft.com/default.aspx?scid=kb;EN-US;814132),
is there a similar problem here? Or is this the normal behavior?
3) Finally, once I add the connection and attach the correct database,
click the test connection button and it tests fine, and the new connection
shows in Server Explore but there is no infomation (example, no tables
listed under tables, not diagrams listed under diagrams). Whats going on?
Thanks!
Bob Day
I am installing a VS 2003 on a different computer, and runninng into some
problems with Server Explorer.
It you go to the bottom of Server Explorer to SQL Servers, the
computer/instance name is listed correctly, all tables and info are correct
and accessible. You can display data, design a table, etc. The problem is
with Adding a Conneciton.
In Server Explorer, when you Add A Connection, in the Data Link Properties
Dialog ...
1) Providers tab, the only provide i can find for SQL is "Microsoft OLE DB
Provider for SQL". I thought their was a native (not OLE DB) provide for
SQL 2000, but I don't see how to add it to the list. I have Imports
System.Data.SqlClient in the Solution Property Page, but that doesn't change
anything. How do I add the correct SQL provider (non OLE DB) ?
2) Connections Tab, "Select or enter a SQL Server Name", there is nothing
listed in the drop down arrow for a running the MSDE Release A instance.
You must mannually type in the computer name\instance name. This seems
non-intuitive to me. At least, it would seem, it would show you available
server instances.
I know there is a bug in Service Manager where it doesn't show the servers
correctly (http://support.microsoft.com/default.aspx?scid=kb;EN-US;814132),
is there a similar problem here? Or is this the normal behavior?
3) Finally, once I add the connection and attach the correct database,
click the test connection button and it tests fine, and the new connection
shows in Server Explore but there is no infomation (example, no tables
listed under tables, not diagrams listed under diagrams). Whats going on?
Thanks!
Bob Day