Post reply

OpenQuery()

  • October 6, 2010 at 10:43 am

    #241372

    Hi,

    I am trying to access .mdb file which has password to open the file.

    EXEC sp_addlinkedserver

    @server = 'TestDB',

    @provider = 'Microsoft.Jet.OLEDB.4.0',

    @srvproduct = 'OLE DB Provider for Jet',

    @datasrc = 'c:\2010 Nielsen Internal 04052010.mdb'

    EXEC sp_addlinkedsrvlogin

    @rmtsrvname = 'TestDB',

    @useself = 'true',

    @locallogin = null,

    @rmtuser = 'Admin',

    @rmtpassword = 'testpwd'

    select * from openquery(TestDB, 'SELECT * FROM EMPLOYESS')

    I am getting the following error:

    [OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.]

    Msg 7399, Level 16, State 1, Line 1

    OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed.

    Could anybody help me out on this issue.

    Thanks,

    Sri.

  • October 6, 2010 at 10:56 am

    #1232820

    Does someone (or you) have the file open?

  • October 6, 2010 at 11:03 am

    #1232824

    Hi,

    No, its just in local system and I used windows account/sql server account to create linked server.

    Thanks,

    Sri.

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

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