OpenQuery()

• SriSun

  Say Hey Kid

  Points: 684

  More actions

  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.

• Derrick Smith

  SSChampion

  Points: 10833

  More actions

  October 6, 2010 at 10:56 am

  #1232820

  Does someone (or you) have the file open?

• SriSun

  Say Hey Kid

  Points: 684

  More actions

  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.