There's quite a few reasons for that "DSN not found" error message - cut and paste the text of the error message (or the error number) into the search function on MSDN (msdn.microsoft.com) and see which one of the results fits your situation.

Also look in the error log (like it tells you in the message) and see if there's anything there that might help you.