IIS Problems
IIS Problems
IIS Problems
IIS Problems
IIS Problems
IIS Problems IIS Problems IIS Problems IIS Problems IIS Problems IIS Problems IIS Problems IIS Problems
IIS Problems IIS Problems
IIS Problems
Go Back  Xtreme Visual Basic Talk > > > IIS Problems


Reply
 
Thread Tools Display Modes
  #1  
Old 09-13-2006, 08:27 AM
Nayru's Avatar
Nayru Nayru is offline
Centurion
 
Join Date: May 2006
Location: GTA
Posts: 119
Default IIS Problems


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:
Code:
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:
Code:
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.
Reply With Quote
  #2  
Old 09-13-2006, 09:59 AM
wayneph's Avatar
waynephIIS Problems wayneph is offline
Web Junkie

Retired Moderator
* Expert *
 
Join Date: Apr 2004
Location: D/FW, Texas, USA
Posts: 8,393
Default

It's been a while since I've done anything with Access, but most of the time when I see this error, someone actually has the Database open with MS Access on their desktop. And that's the user that has it exclusively. Make sure no one is trying to modify the database when this problem occurs.
__________________
-- wayne, MSSM Retired
> SELECT * FROM users WHERE clue > 0
0 rows returned
Reply With Quote
  #3  
Old 09-13-2006, 10:16 AM
Nayru's Avatar
Nayru Nayru is offline
Centurion
 
Join Date: May 2006
Location: GTA
Posts: 119
Default

That was one of the first things I checked, but this is a new test project that only 4 or 5 (extremely computer illiterate) people in the company know about.

No one except me has ever opened the database through access.

Thanks though
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
IIS Problems
IIS Problems
IIS Problems IIS Problems
IIS Problems
IIS Problems
IIS Problems IIS Problems IIS Problems IIS Problems IIS Problems IIS Problems IIS Problems
IIS Problems
IIS Problems
 
IIS Problems
IIS Problems
 
-->