Take a look at this KB article:
http://support.microsoft.com/kb/306212
Though the error that you are getting seems to indicate that the ODBC DSN connection itself is not working. Did you create it as a SYSTEM DSN ? If the DSN connects fine and if it is a system DSN, then take a look at the KB above and see if that helps.