Post reply

Openrowset works first time only for access

  • 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.

  • 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...

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

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