Nayru
09-13-2006, 08:27 AM
I am trying to set up an ASP.net 2.0 program I wrote on the test server, it worked great on my local machine but since I moved it I've been having a lot of trouble. I am not too familiar with IIS but I tried all of the possible solutions I could find online to this problem to no avail.
If more than one user is logged on they can't access the DB attached the program (Access database using NT login information). I've done this with quite a few other asp.net applications, I just can't figure out why it's throwing these errors this time. Almost everything I've found online has said that it's a result of imporper security settings.
I have given modify access to the program folder (in inetpub/wwwroot) to the everyone group and explicitly gave modify permissions to the ASPNET account, IIS Process Account (IWAM), and the Internet Guest Account (IUSER). I know giving "Everyone" modify access is probably not the best idea, but it's on a test server that can only be accessed through our intranet and I'm stumped as to how to fix this problem.
These are the exact two error messages I get at any line that tries to open the DB connection:
System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open
the file c:\inetpub\wwwroot\MaintTrackIT\app_data\maintenance.mdb'.
It is already opened exclusively by another user,
or you need permission to view its data.
and
could not open ' '; file already in use
And the connection string:
Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\inetpub\wwwroot\MaintTrackIT\app_data\maintenance.mdb;
Mode=Share Deny None;
There's probably a really easy solution here that I'm overlooking, but like I said I am not very familiar with IIS. Actually, this is the first time I've had to set up IIS for a project, the sys admin has done it for me all other times, but he's got no ideas about this either.
Any help would be greatly appreciated.
If more than one user is logged on they can't access the DB attached the program (Access database using NT login information). I've done this with quite a few other asp.net applications, I just can't figure out why it's throwing these errors this time. Almost everything I've found online has said that it's a result of imporper security settings.
I have given modify access to the program folder (in inetpub/wwwroot) to the everyone group and explicitly gave modify permissions to the ASPNET account, IIS Process Account (IWAM), and the Internet Guest Account (IUSER). I know giving "Everyone" modify access is probably not the best idea, but it's on a test server that can only be accessed through our intranet and I'm stumped as to how to fix this problem.
These are the exact two error messages I get at any line that tries to open the DB connection:
System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open
the file c:\inetpub\wwwroot\MaintTrackIT\app_data\maintenance.mdb'.
It is already opened exclusively by another user,
or you need permission to view its data.
and
could not open ' '; file already in use
And the connection string:
Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\inetpub\wwwroot\MaintTrackIT\app_data\maintenance.mdb;
Mode=Share Deny None;
There's probably a really easy solution here that I'm overlooking, but like I said I am not very familiar with IIS. Actually, this is the first time I've had to set up IIS for a project, the sys admin has done it for me all other times, but he's got no ideas about this either.
Any help would be greatly appreciated.