SQL Server ODBC connection

[mkov]

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.

 

[genomon]

Go to control panel and open Administrative Tools. Choose Data Sources (ODBC). On one of the DSN tabs (user, system, file - whichever you need) you can either Add or Configure the new data source. I am guessing the last machine does not have it set.

 

[JPdev]

I came across this problem and i thought it might be a dns issue, but this doesn't seem to have changed anything. I'm suspecting some kind of permissions issue? Its Win2K pro and it works on every other Win2K machine i've used ?

 

[mkov]

I fixed my problem by installing the MDAC 2.8 driver.