[dba-SQLServer] ODBC error when Server is down with unused linked table

A linked table will cause this, even if it is never used. How is the app to know that the table is never used? If you're using ODBC then you're linking to tables and therefore bad references will create this problem. The simplest solution, I think, is to fire up the Linked Table Manager and delete the references to obsolete tables.

Arthur

----- Original Message ----
From: "askolits at ot.com" <askolits at ot.com>
To: dba-SQLServer at databaseadvisors.com
Sent: Wednesday, November 22, 2006 11:54:03 AM
Subject: [dba-SQLServer] ODBC error when Server is down with unused linked table

I ran into a problem where a database had an ODBC errors when an old server
was shut down. This ODBC linked table was 'not' being used by the database.
It was just left over from an old system.

My customer shut down the server and the MDB timed out with an ODBC error
even though the table is not used in anywhere in the database. At least I
haven't found any use.