Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.sqlserver.connect > #1

Re: Linked Server Error Help Required

Show all headers | View raw

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.

 

On Wednesday, May 7, 2008 at 5:11:55 PM UTC-7, Ugo wrote:
> 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

Back to microsoft.public.sqlserver.connect | Next | Find similar

Thread

Re: Linked Server Error Help Required hitzeman.todd@gmail.com - 2017-01-05 19:00 -0800

csiph-web