Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    2

    Unanswered: Intermittent query failures sing linked server

    Using SQl Server 2008 R2, have a linked server to pervasive SQL 11:

    EXEC master.dbo.sp_addlinkedserver
    @server = N'LTN',
    @srvproduct=N'CYMA4',
    @provider=N'MSDASQL',
    @datasrc=N'CYMA4'


    I can run queries for most of the day and then the same queries will not run. If I wait until the morning, they will run again. Is this a connection issue - too many connections? Have been told that query will not run if my ERP (CYMA) is updating the table begin referenced in the query? Cannot believe this is the case. Any ideas?

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    What's the error?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    May 2012
    Posts
    2
    Will post error message next time I get it.

    Thanks!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •