Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 4th, 2005, 02:07 PM
Registered User
 
Join Date: Feb 2005
Location: Hamptonville, NC, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
  #2 (permalink)  
Old February 4th, 2005, 04:08 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Is there a lock file generated for the database? Otherwise, I believe the IUSR_<machine name> needs access.

Brian
Reply With Quote
  #3 (permalink)  
Old February 4th, 2005, 05:28 PM
Registered User
 
Join Date: Feb 2005
Location: Hamptonville, NC, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4 (permalink)  
Old February 7th, 2005, 09:09 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

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
Reply With Quote
  #5 (permalink)  
Old February 7th, 2005, 10:15 AM
Registered User
 
Join Date: Feb 2005
Location: Hamptonville, NC, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Reply With Quote
  #6 (permalink)  
Old February 7th, 2005, 05:47 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Is this access database on the same server as the web application? That's the only other thing I can think of.

Brian
Reply With Quote
  #7 (permalink)  
Old February 8th, 2005, 02:42 PM
Registered User
 
Join Date: Feb 2005
Location: Hamptonville, NC, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #8 (permalink)  
Old February 9th, 2005, 02:08 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

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
Reply With Quote
  #9 (permalink)  
Old February 15th, 2005, 11:39 PM
Authorized User
 
Join Date: Dec 2004
Location: Palestine, Texas, USA.
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Permissions Problem dparsons ASP.NET 1.0 and 1.1 Professional 0 June 22nd, 2006 08:14 AM
Setting SQL Server 2000 access permissions / Syste snejsnej SQL Server 2000 1 May 18th, 2006 08:10 AM
Modifying User Access Permissions to Folders (VB) gakhar Pro VB 6 0 April 14th, 2004 01:20 AM
Getting Access permissions mont2004 Access ASP 1 February 12th, 2004 02:35 PM
How to manage NTFS folder access permissions Dmitriy Pro VB 6 0 August 7th, 2003 08:57 AM



All times are GMT -4. The time now is 01:25 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.