SQL Server Linked Server to ODBC Connection Drops connection every 4-5 minutes

Hey Kristen, The OP is limited by vendor software. That's why he has to do it RBAR. He can't see (let alone change) the code at the vendor's end. I suspect that code is not well written. But there you go!