I finally got it to work.
It seems the machine is having problems with its DNS.
In the odbc settings, I changed the server name from the IP address (which is how I had been doing it) to the name of the server and it was able to connect to the server. For whatever reason it no longer recognized the IP address as a name for the named pipe and required the server alias instead.
The user is having several other network problems as well and I think he is going to end up reformatting and reloading at this point anyway.
Thanks for all of your help Mike.

Ryan Uhl