They are connecting with an application installed on their desktop client, which uses and ODBC connection.

Since I'm not the system analyst I do not know much about the program except that it was built to run on SQL 2000 so we are running it in compatibility mode.

I've considered installing SNAC but I read a Microsoft article that advised against it for apps built on 2000 or earlier that are running in a 2005 environment, apparently the old driver is more compatible.

I don't know what I'm over looking - I guess that's what I'm asking from the community... any ideas?

Thanks for your input!