Linked Server Error Help Required

From: "Ugo" <Ugo@xxxxxxxxxx>
Date: Thu, 8 May 2008 10:11:55 +1000

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

.

Follow-Ups:
- RE: Linked Server Error Help Required
  - From: Sean McCown

Prev by Date: Re: Linked Server Connection Error: 18459
Next by Date: Re: SOAP Endpoint: How to Receive RAISERROR as Exception?
Previous by thread: Re: SOAP endpoint: Doesn't publish user defined table functions - why?
Next by thread: RE: Linked Server Error Help Required
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL linked server with ODBC
... and then run the query. ... I am having trouble extracting data from a Navision ... I am using sql server 2000. ... I created a linked server using OLE DB provider ...
(microsoft.public.sqlserver.odbc)
Temp table from text file connected via Linked Server
... I have a text file as a table in a linked server. ... statement to query the file, changing the name of the file. ... SELECT TextFile.* ... DECLARE @strFileName varchar ...
(microsoft.public.sqlserver.programming)
RE: sp_runwebtask remote access error
... Did you find out if there was a bug for this issue? ... >and that prevents a linked server query from being called ... >Vikrant Dalwale ...
(microsoft.public.sqlserver.security)
Re: Error with Linked Servers
... is it large set data you want to return? ... But the problem isn't so much in the query it's the fact that when you ... select the linked server the system hangs with no error message and the ... the session hangs and no error message is displayed. ...
(microsoft.public.sqlserver.security)
Re: problem with Execute SQL Task
... I found out that the problem for the failure is due to a linked server query ... i did in my batch query. ... If this DTS package is run manually it works but when i schedule it to run ...
(microsoft.public.sqlserver.dts)