Access Linked Server Breaks

Hi,

1. I have a SQL2000, SP3 Linked Server to an Access mdb that breaks every
couple of weeks. If I do a SELECT statement to the Linked server in Query
Analyzer,, even on a small table of 3 records, QA seems to be working, and
no error messages come up. However, the SELECT command never completes.

2. This problem can always be cured by a reboot of server, but then it
happens again a few days or a few weeks later.

3. This exact same setup worked on another server for 1 3/4 years, but the
problem is on a newly set up SQLServer box.

4. Has anyone experienced such symptoms and found a resolution for sporadic
Linked Server to mdb failures?

5. When a Linked Server connects to an Access mdb, is this being done via an
IP connnection?

I believe a couple of years ago I had viewed the linked server process in
motion, showing among other things some IP connections, but I don't remember
how I did that.

Thanks for any help.

Alan


.

Relevant Pages

  • Re: Access Linked Server Breaks
    ... issue (the portion of SQL Server process memory that is not the buffer ... than suggesting running DBCC FREEPROCCACHE instead of restarting sql server ... If I do a SELECT statement to the Linked server in Query ... sporadic Linked Server to mdb failures? ...
    (microsoft.public.sqlserver.connect)
  • Re: Access Linked Server Breaks
    ... I will try that next time Linked server breaks. ... Real-world stuff I run across with SQL Server: ... This problem can always be cured by a reboot of server, ... sporadic Linked Server to mdb failures? ...
    (microsoft.public.sqlserver.connect)
  • 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)
Loading