Re: Linked Server connection Problem

From: Jose Molina (rcmaniac23_at_yahoo.com)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 09:25:00 -0800

Hi Alan,
Have you verified that the connection is actually being made to the linked
server? Check the process info on the destination server to see if a
process ID has been generated by your request. If not, then check your
firewall logs to see if your request is not making it to its intended
target. Hope this helps! Let me know what your results are and we can dig
deeper if need be.

-Jose

"Alan Z. Scharf" <ascharf@grapevines.com> wrote in message
news:uR2IxZk$EHA.3988@TK2MSFTNGP11.phx.gbl...
> SQLServer2000
> Access 2000
> Windows Server2003
>
> 1. I had a Linked Server to an Access 2000 database which had worked for
> two
> months.
>
> 2. Hoever, now when I execute queries againt it in Query Anayler, e.g.
>
> SELECT * FROM LINKEDSERVERNAME...TableName
>
> The query Analyzer just says "Executing query batch" and stays there for
> several minutes. No error messages. Pressing red button to end query
> puts
> QA into 'Progran not responding mode'. No error messages in QA.
>
> 3. If I go to Linked Server in EM and click on Tables or Views, most of
> the
> time I get same thing - i.e. just hourglass for minutes.
>
> Somtimes in EM when I click on Linked Server Tables or Views, I get Error:
>
> Error 0: SqlDumpExceptionHandler:Process 51 (or 55) generated fatal
> exception 0000005 EXCEPTION_ACCESS_VIOLATION. SQLServer is terminating
> this
> process.
>
> 4. Only one time, time in EM, when clicking on Linked Server Tables, I got
> Error 7339:OLE_DB Provider Microsfot.Jet.OLEDB reported an error.
>
> 5. I tried finding answers to this in Google, but to no avail.
>
> Any help would be appreciated. Thanks.
>
> Alan
>
>