Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server ",

• jamessdba

  SSCrazy

  Points: 2254

  More actions

  September 27, 2011 at 4:03 am

  #248469

  We have configured Linked server one of our Production SQL server 2005 Enterpice Edition BOX

  Often we are facing the error while retrieving the DATA

  Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server ",

  Temporarily we are restarting the sql services and it solves the problem, however the next 20days the problem is back. Any ideas?

  any suggestions Please

  Thanks in advance

• jamessdba

  SSCrazy

  Points: 2254

  More actions

  September 28, 2011 at 3:01 am

  #1387606

  Hi,

  Any suggestions pls