Hello everyone,
Here's a stumper for you, or maybe I'm really missing something? I'm writing an ASP.NET web form (VB.NET) that queries a database contained on a server other than the web server. We have to have it this way because of the trust relationship between our two domains (the domain with the database is not trusted by the domain with the web server, while the database's domain trusts the web server's). I keep getting the "The Microsoft Jet database engine cannot open the file 'blah blah blah'. It is already opened exclusively by another user, or you need permission to view its data." Error. The database has full control to Everyone and the share does as well. In addition, I have configured .NET to recognize the .dll file for my ASP.NET application as a trusted assembly, and have the machine.config and web.config files running with SYSTEM rights (the lowest security possible). No matter what I try I cannot seem to get at what is causing the error. Has anyone out there seen this type of behavior? One theory I have is that since the machine.config file is configured to run under SYSTEM that the ASP service cannot access the database since you can't assign user rights to the SYSTEM account.. or is that covered when you give Everybody access rights to a file and its share? Any help would be much appreciated!
--文学城www.wenxuecity.com--