Named Instance not Displaying Only Server Name

I have a Dell Latitude D505 running a fresh copy of XP SP2. I am trying to
create an ODBC System DSN to our SQL 2k server. The SQL Server has about 6
instances installed on it. When I pull down the drop down box to select a
server, only the server name exists, but none of the instances. This is
working on 180 desktops configured off the same image of XP.
Basically, I am seeing:
<Server Name> instead of <Server Name>\<Instance>
<Server Name>\<Instance 2>
Just so you know, I have already updated the MDAC version, so that cannot
be the issue.
|||This is all set now. My issue was the wireless network being enabled. As
soon as I disabled it, it worked fine.

Named Instance not Displaying Only Server Name

I have a Dell Latitude D505 running a fresh copy of XP SP2. I am trying to
create an ODBC System DSN to our SQL 2k server. The SQL Server has about 6
instances installed on it. When I pull down the drop down box to select a
server, only the server name exists, but none of the instances. This is
working on 180 desktops configured off the same image of XP.
Basically, I am seeing:
<Server Name> instead of <Server Name>\<Instance>
<Server Name>\<Instance 2>Just so you know, I have already updated the MDAC version, so that cannot
be the issue.|||This is all set now. My issue was the wireless network being enabled. As
soon as I disabled it, it worked fine.

MySQL Linked Server

I am trying to linka mysql database to SQL 2005, but I am not sure what I
need to do.
I have set up a DSN using the mysql driver. I get lost when I try and create
the linked server in SQL 2005. Can someone please outline the steps to creat
e
the linked server. Should the mysql driver show up as a provider in SQL 2005
?Select the Microsoft OLE DB Provider for ODBC Drivers. Form
there, enter the DSN name for the Data source.
-Sue
On Thu, 16 Mar 2006 17:07:27 -0800, Curtis
<Curtis@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I am trying to linka mysql database to SQL 2005, but I am not sure what I
>need to do.
>I have set up a DSN using the mysql driver. I get lost when I try and creat
e
>the linked server in SQL 2005. Can someone please outline the steps to crea
te
>the linked server. Should the mysql driver show up as a provider in SQL 2005?[/vbco
l]

MySQL Linked Server

I am trying to linka MySQL database to SQL 2005, but I am not sure what I
need to do.
I have set up a DSN using the MySQL driver. I get lost when I try and create
the linked server in SQL 2005. Can someone please outline the steps to create
the linked server. Should the MySQL driver show up as a provider in SQL 2005?
Select the Microsoft OLE DB Provider for ODBC Drivers. Form
there, enter the DSN name for the Data source.
-Sue
On Thu, 16 Mar 2006 17:07:27 -0800, Curtis
<Curtis@.discussions.microsoft.com> wrote:

>I am trying to linka MySQL database to SQL 2005, but I am not sure what I
>need to do.
>I have set up a DSN using the MySQL driver. I get lost when I try and create
>the linked server in SQL 2005. Can someone please outline the steps to create
>the linked server. Should the MySQL driver show up as a provider in SQL 2005?