error 7421 Cannot fetch the rowset from OLE DB provider "SQLNCLI10" for linked server "IDb". .

• komal145

  SSCrazy Eights

  Points: 9915

  More actions

  June 22, 2012 at 12:09 pm

  #257857

  hi,

  I am running a stored procedure , in which I am getting rows from linked server.Its runs for 13mins and then I get following error:

  Cannot fetch the rowset from OLE DB provider "SQLNCLI10" for linked server "IDb". .

  The tables on linked server has lot of data so I am getting only million by million.

  can anyone suggest what would be the issue???

  thanks in advance!!

• GED.Burnett 71559

  SSC-Addicted

  Points: 430

  More actions

  November 7, 2016 at 8:04 am

  #1910927

  I have the same issue with a linked server.

  Did you manage to resolve this one?

  Thanks,

  Ged