Thanks for that. I ended up doing that but I'm still confused as to why failures don't result in being handled as soon as they go in the agent.

Scrap that. I figured out a really simple way of dealing with it.

Lowell,

Same error as before.

It appears that it has to be told exactly where to go, then when it goes there, that is when the failure occurs.

I think it's all down...

Lowell,

By doing that I get the following error message:

Msg 7313, Level 16, State 1, Line 1

An invalid schema or catalog was specified for the provider "Ifxoledbc" for linked server "LIVE".

I ran that proc and it gave me a list of all the tables including the one I was testing the link against.

So from what I can see, the linked...