Openrowset works first time only for access

• etrobin

  SSC Enthusiast

  Points: 116

  More actions

  March 30, 2010 at 3:02 am

  #96910

  hi,

  When i use openrowset to fetch data from access, it works only once. After that i have to restart the sql server services. Then only I can access the db. I am getting an error message

  OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.".

  Msg 7303, Level 16, State 1, Line 3

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

  But I am able to access excel using openrowset. OS is Windows 2003 server.

  Can anybody tell me what could be the reason.

• whitetool2084

  SSC Enthusiast

  Points: 153

  More actions

  May 5, 2011 at 9:56 am

  #1320514

  i have the same problem (posted here). but after a minute the openrowset works well again for another minute of errors like this(no need to restart the services):

  Msg 7399, Level 16, State 1, Line 1

  The OLE DB provider "MSDASQL" for linked server "(null)" reported an error. The provider did not give any information about the error.

  Msg 7303, Level 16, State 1, Line 1

  Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

  i think is something related to a mdb locked file by the sql proccess...