Linked Server Errors Help - Ugo

I have setup a Linked Server Using ODBC connection
Named hc

I am using the following Query

Select * From Openquery(hc,'Select * from Tent')

on my test server it works on the client site I get the following.

What Would Cause the following errors and how do I resolve them?
Msg 7399, Level 16, State 1, Line 1

ERROR1:
The OLE DB provider "MSDASQL" for linked server "hc" reported an error. The
provider reported an unexpected catastrophic failure.

ERROR 2:
Msg 7321, Level 16, State 2, Line 1

An error occurred while preparing the query "select * from tent" for
execution against OLE DB provider "MSDASQL" for linked server "hc".

Any Ideas

sam