I have had time out nightmares in the past. What I normally have done to resolve them is to tweak my query and add or adjust indexes on the tables...

I went back an tested it in the application I am using it for. I have numbers from 1 to 70 with some As and Bs(34A,34B) thrown in here and there....

dag gum! That worked great!!! Thanks!

I code therefore I am....

Thank you I will try your suggestions.  The tables are being touched by a couple different applications in different ways and I want a central point where I can tell who...

To be on the safe side we installed Pervasive client tools on both nodes of our cluster set up the DSN on both nodes and the linked servers work great....

That would make it too easy. lol

I have tried that but have been getting this error.

Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not...