ODBC Connection to SQL Server

I am setting up SQL Server ODBC connections on 5 machines
and everything has gone fine until I came to the last
machine.
When I go to choose the server I want to connect to from
the server drop down list, it isn't there. There other
machines listed, but not the one that I want.
The only difference is that this one has 2000 pro, while
all of the others have XP pro. I am assuming that I need
to update something on the 2000 machine, but don't know
what. Can anyone help me with this?
Thanks in advance.You should check the MDAC version, installation on the
machine that's having problems. If the versions are
different between the xp machines and the 2000 machine,
you'd want to upgrade the 2000 machine to the same MDAC
version.
You can download the MDAC component checker
from:
http://msdn.microsoft.com/data/down...ls/default.aspx
-Sue
On Fri, 16 Apr 2004 07:52:32 -0700, "Mark Kovach"
<anonymous@.discussions.microsoft.com> wrote:

>I am setting up SQL Server ODBC connections on 5 machines
>and everything has gone fine until I came to the last
>machine.
>When I go to choose the server I want to connect to from
>the server drop down list, it isn't there. There other
>machines listed, but not the one that I want.
>The only difference is that this one has 2000 pro, while
>all of the others have XP pro. I am assuming that I need
>to update something on the 2000 machine, but don't know
>what. Can anyone help me with this?
>Thanks in advance.|||Thanks. I downloaded MDAC 2.8 and installed it. It
works great now.
Thank you for the help.

>--Original Message--
>You should check the MDAC version, installation on the
>machine that's having problems. If the versions are
>different between the xp machines and the 2000 machine,
>you'd want to upgrade the 2000 machine to the same MDAC
>version.
>You can download the MDAC component checker
>from:
>http://msdn.microsoft.com/data/down...ools/default.as
px
>-Sue
>On Fri, 16 Apr 2004 07:52:32 -0700, "Mark Kovach"
><anonymous@.discussions.microsoft.com> wrote:
>
machines[vbcol=seagreen]
from[vbcol=seagreen]
while[vbcol=seagreen]
need[vbcol=seagreen]
>.
>