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

John Skolits askolits at ot.com
Sat Nov 25 07:32:27 CST 2006

Thanks for the info. Not exactly sure the best way top handle things but
just using the link manager may be the best way to go.


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
artful at rogers.com
Sent: Wednesday, November 22, 2006 12:43 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] ODBC error when Server is down with
unusedlinked 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.


----- 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

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.


dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list