Server Explorer Issues

[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

 

[Miha Markic]

Hi Bob,

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) ?

It Microsoft OLE DB Provider for SQL is just fine. Note that Data Link
Properties is used just for creating connection strings.

 

[Kevin Yu [MSFT]]

Thanks for Miha's response.

Hi Bob,

1. The SQL server native provider is used for programming with the
System.Data.SqlClient namespace. However, at design time, we we have to use
OleDb for SQL server driver.

2. This is a known issue that sometimes the server names will not be listed
correctly in the dropdown list. Please try to upgrade your MDAC to the
latest version for recovery(currently 2.8). You can download it from the
following link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-
b037-185d0506396c&DisplayLang=en

3. Have you created any tables in the database? To create a table in the
database, right click Tables and choose New Table from the pop up menu? You
can also choose Refresh to refresh the list of tables.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

 

[Bob Day]

Upgrading to MDAC 2.8 solved all problems in this post.
Thanks for your help!

Bob Day