Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server 
Author Message
 Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

I'm getting the same Server: Msg 7399, Level 16, State 1, Line 1 that
many other people have reported.  I've looked at KB Q285833 but, while
it addresses Server: Msg 7399, Level 16, State 1, Line 1, it doesn't
address the specific error that is listed in the extended text.
(QB241267 has the extended text but doesn't appear to apply either).

 Here is the full error:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.  
[OLE/DB provider returned message: The Microsoft Jet database engine
cannot open the file 'fullUNCpathtomdb'.  It is already opened
exclusively by another user, or you need permission to view its data.]

(note that I made the database path generic but otherwise that's a
straight quote)

I've set up the linked server properly (i.e. it's going in with the
Admin user and a null password).  When I got this error I thought I
had it{*filter*}ed: I went in and found that the service account was
configured to the local machine and thus couldn't get out to the
network share.  I changed it to my account, stopped and restarted the
service.  But now I get the exact same error.  And, importantly, the
file is NOT opened exclusively by another user.  It's got to be the
permissions thing.

Any help with this would be greatly appreciated: this is so
frustrating.  I had very similar bad experiences with this very
database in IIS that I still don't have{*filter*}ed (i.e. it gave a
somewhat cryptic error when the problem was that the account IIS
impersonates couldn't get to the network shares).  

I hope someone can help with this or that this perhaps illimunates
past discussions on the topic.  I really need this to work; it will
make things so much easier!

Mike Lerch



Tue, 07 Jun 2005 03:21:43 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

2. Server: Msg 7399, Level 16, State 1, Line 1

3. Help.Error: Msg 7399, Level 16, State 1, Line 1

4. Server: Msg 7399, Level 16, State 1,

5. Select error:Server: Msg 8120, Level 16, State 1, Line 1

6. Server: Msg 8114, Level 16, State 1, Procedure co_AddTrader_Information, Line 0

7. Server: Msg 18757, Level 16, State 1, Procedure sp_repldone, Line 333 The databa

8. Server: Msg 547, Level 16, State 1, Line 6

9. Server: Msg 8115, Level 16, State 2, Procedure sp_monitor, Line 94

10. Unable to use sp_AddRole = Server: Msg 8114, Level 16, State 4, Procedure sp_addrole, Line 0

11. Server: Msg 4321, Level 16, State 1, Line 2

12. Server: Msg 7619, Level 16, State 1, Line 1


 
Powered by phpBB® Forum Software