Post reply

Linked Server Oddity

  • July 7, 2011 at 7:09 am

    #389923

    Hi All

    I've been having a bit of an odd problem recently, that I'm hoping you may be able to help with...

    I support a data warehouse on a customers server, and every once in a while the data loads will fall over because of a problem with the linked servers it uses. Nothing has changed, and restarting the instance of SQL (2008) fixes the problem.

    The restart is generally ok because the customer is 5 hours behind us thanks to the logistics of the globe, so the server is never doing anything other than the data load, but still, its not ideal.

    Any ideas what may be causing this? Can linked servers get their nickers in a twist? (There is nothing showing up in the application or system logs on the server)

    Thanks 😀

  • July 7, 2011 at 7:22 am

    #1349675

    Which provider is used by the linked server?

    -- Gianluca Sartori

  • July 7, 2011 at 7:24 am

    #1349680

    BillyUnsy (7/7/2011)

    Can linked servers get their nickers in a twist? (There is nothing showing up in the application or system logs on the server)

    Unfortunately they can. Take a look at this article and see if you find something of your interest:

    Setting up linked servers with an out-of-process OLEDB provider[/url]

    hope this helps

    Gianluca

    -- Gianluca Sartori

  • July 7, 2011 at 7:47 am

    #1349707

    Thanks for you reply. Its OraOLDB.Oracle.

  • July 7, 2011 at 7:54 am

    #1349713

    Thank you Gianluca. Thats a great article.

    Unfortunatly I'm not authorised to change the settings of linked servers or the providers as the servers are owned by my customer, but I will send your article onto them in hope that they will try it, and hopefully fix the issue.

    Thank you very much for your help.

  • July 7, 2011 at 8:15 am

    #1349736

    Glad I could help.

    -- Gianluca Sartori

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply