BUG: Opening a Long-Running View from SQL Server Enterprise Manager Gets ODBC Timeout

• Microsoft SQL Server versions 7.0, 7.0 Service Pack 1

SYMPTOMS

Opening a view that executes a long running query in the SQL Server 7.0 Enterprise Manager (SEM) will get an ODBC Timeout error.

CAUSE

The SEM's default for QueryTimeout is 30 seconds, and the timeout value is not configurable.

RESOLUTION

Do not open long running queries from the SEM. Run the query from Query Analyzer instead of SEM.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

Additional query words:

Keywords : SSrvEntMan odbcSQL kbSQLServ700 kbGrpMDAC kbDSupport kbGrpODBC
Version : winnt:7.0,7.0 Service Pack 1
Platform : winnt
Issue type : kbbug