Our IT department made an application that connects to my SQL server. It updates the record in the SQL server and then updates a corresponding record in another server.

It was working great until earlier in the afternoon. Now, when it tries to update the record, it produces that error message.

I've done everything I could think of and IT has helped me as far as their willing. I can't think of anything else at the moment. I checked the ODBC connections to make sure they were working. I checked the user mapping and everything. I even made a quick a simple app to update one of those records, bypassing ODBC altogether and it works just fine.

I've Googled this issue and their seems to be a lot of people who have this problem, but no one with a concrete solution.

Does anyone have any ideas on what I could do to maybe fix this?