Unanswered: [Microsoft][ODBC SQL Server Driver] Timeout Expired
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.