Post reply

SQLOLEDB Error with Linked Servers

  • July 2, 2002 at 2:57 am

    #63172

    Hey,

    We have a problem here with a linked server. We run SQL7 and I have connected to SQL2K over the WAN. Due to politics and all that, they don't want us to replicate so we simply copy the tables we require. We also push data to their servers too.

    This morning, a job failed with the following error..

    OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312). The step failed.

    To fix this, I simply right clicked on the Linked Server and Refreshed it. The job now worked fine. I have had other jobs fail with the same error on occasion.

    Could this be due to us using SQL7 and linking to SQL2K (We will be upgrading soon!)?! At first, I thought maybe they had rebooted their server or possibly doing maintenance work on them.

    Any thoughts/suggestions?

    Thanks,

    Clive Strong

    clivestrong@btinternet.com

  • July 2, 2002 at 9:43 am

    #431981

    I'd guess network issue. Could be versioning.

    Is there a reason you don't use DTS?

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • July 2, 2002 at 10:29 am

    #431992

    Hey Steve,

    Thanks for the response...

    I could try a DTS. Basically I am running a SP on the server in the US office.

    I'll create it in a DTS and see if that resolves things.

    Thanks

    Clive Strong

    clivestrong@btinternet.com

Viewing 3 posts - 1 through 2 (of 2 total)

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