 |
| Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
February 4th, 2005, 02:07 PM
|
|
Registered User
|
|
Join Date: Feb 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Access Permissions problem
Hello all - I need your help.
I am using classic ASP 3.0
I have a web app that will not connect to the Access database.
Error:It is already opened exclusively by another user, or you need permission to view its data. - And no else is connected to it yet. I am not using Interdev at the time of error- just IE 6.0 but it happens when Interdev is opened as well.
The details: Web server IIS 5.0 on a Windows 2000 platform.
The database is on the PDC - Primary Domain Controller
The web server is a member of the domain. THe PDC is a Windows NT server. THe IUSR_websvr account has full control rights to the database and its parent folder and that user is a member of the domain. It also has full control rights to the WINNT folder on both machines - web server and PDC. THe web app security is anonymous access and allows IIS to control the password.
The database includes tables linked to another database in the same directory. The Link path uses the fully qualified server path.
The provider string in the app also uses a fully qualified path:
conStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=\\Rdt_bdc\Training Tracker\trainingmonitor.mdb"
Ok I hope that I provided all the clues. When I start the web app it looks like it is trying to connect for about 10 seconds before it errors out. I believe that it is a permission problem but I do not know what I missed.
Thanks all in advance
|
|
February 4th, 2005, 04:08 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
|
|
Is there a lock file generated for the database? Otherwise, I believe the IUSR_<machine name> needs access.
Brian
|
|
February 4th, 2005, 05:28 PM
|
|
Registered User
|
|
Join Date: Feb 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Yes there is a lock file generated when this db is opened. IUSR_websvr has full control/rights access to the folder and the files contained within. That would cover the lock file, right. Thanks
|
|
February 7th, 2005, 09:09 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
|
|
The lockfile generated is not a permissions problem (because nothing has permissions to it); it's means that if there is a lockfile before the computer accesses the database, then this error occurs. The USR_websvr won't be able to access it in this respect.
Do you have it open before you run the app?
Brian
|
|
February 7th, 2005, 10:15 AM
|
|
Registered User
|
|
Join Date: Feb 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
No The lock file doesn't exist before the app tries to access the database. I assume that one is generated when the app opens the db. All of my other dbs will generate a ldb file when a web app accesses it.
|
|
February 7th, 2005, 05:47 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
|
|
Is this access database on the same server as the web application? That's the only other thing I can think of.
Brian
|
|
February 8th, 2005, 02:42 PM
|
|
Registered User
|
|
Join Date: Feb 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
No it is not on the same server. The web app is on a Windows 2000 platform and the db is on a Windows NT server which is the Primary Domain Controller - both app and db on same domain
|
|
February 9th, 2005, 02:08 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
|
|
I know we've had problems accessing a database on the same server, where the app couldn't "see" the access database. That may be what you are experiencing.
Brian
|
|
February 15th, 2005, 11:39 PM
|
|
Authorized User
|
|
Join Date: Dec 2004
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
you might have full rights to the folder where the db resides. but, do all files and subfolders have the same rights. please double check, if it does then you need to run take ownership from primary domain controller or has two way trust been established? Other thing to check, primary domain controller does not have IUSR_websvr account it only gets installed when you install IIS.
Mike
|
|
|
