I'm having a heck of a time getting some ASP.NET code to run locally on XP with MDAC/ADO talking to a local access db. I know the code runs fine on IIS on Win2000 and Win2003. When I move it to my local XP system it won't work.
Anybody dealt with these issues in terms of permissions.
I opened up the permissions on the /temp folders. The issue seems to be that an .ldb file is created as the database is locked but it never seems to release it. The asp.net code just sits there an hangs with no error message.
Oh, sorry, I need to add a few things that folks are going to suggest.
1. All database connections are closed. In fact, the code runs fine on a real IIS server...so there is no chance that this is the problem.
2. Permissions. ASPNET, IUSR, System, Admin and WADMNET, USERS, etc. have Full Control to the folder and all files underneath.
Yes XP permssions config is hidden so you have to enable it to run. Try the url below for the steps. Hope this helps.
http://whoozoo.co.uk/winxpFilePerms.htm
Try the link below to see the database permissions. Hope this helps.
http://duhnetnuke2.net/Default.aspx?tabid=64
No, unfortunately, the first link shows you how to enable the sharing dialog and the file security dialogs in XP. I already have them enabled...I have too since as I already stated, I have set the permissions correctly on the .mdb and folder. Thats how I set the ASPNET account to have Full Control and IUSR_machinename account to have full control of the .mdb as well as the folder where the .mdb is located.
The second link describes using a SQL database. I really need this to work with Access locally.
However, I have gone through all of the things is the article to make sure thats what I got and confirm that my computer is set this way.
I still have the same problem. The database is permantly and perpetually locked with any single and with the first asp.net ADO access to it. Its never released--and thats the issue.
0 comments:
Post a Comment