Linked Server Error Help Required

[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

[Sean McCown]

Well, do you have the odbc driver setup on the client box? Quite often I
find that someone has not configured something correctly on both systems.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com

[hitzem...@gmail.com]

This is super old but I spent a long time figuring out how to resolve this issue. Restarting the SQL Server service actually fixed the issue.