I've registered another SQL Server 2000 via another SQL Server 2000 and I'm getting the error message in the title line above when I try to open a view in SQL Server, this is after about 15 seconds. It looks like an ODBC connection timesout while connecting to the remote server, but I do not know how to access it's properties.

I'm unable to find where this time out can be reset. I reset the query timeout in the properties of where the server is registered but this is not having any impact.

MDAC 2.7, 2.7 and 2.8 are installed on this machine.

Any help would be very much appreciated.