The Straight Dope

Go Back   Straight Dope Message Board > Main > General Questions

Reply
 
Thread Tools Display Modes
  #1  
Old 11-17-2007, 04:28 PM
Lobsang Lobsang is offline
Member
 
Join Date: Mar 2002
Location: Douglas, Isle of Man
Posts: 18,213
Web server ASP SQL help please.

I'm porting a simple cms (content management system) from one web server to another. It uses an MS access database to store the content.

The problem I'm getting is every second asp query attempt fails because the first attempt seems to have locked the file or left it open.

The first try always works. The second try causes the following error...

Provider error '80004005'
Unspecified error


Sometimes it causes a different error such as file (unknown) is already open.

I have the permissions for IUSER set to read write and execute
Reply With Quote
Advertisements  
  #2  
Old 11-17-2007, 09:59 PM
ZipperJJ ZipperJJ is offline
And Finn The Human
Charter Member
 
Join Date: Aug 2001
Location: Northeast Ohio
Posts: 18,814
Are you closing/destroying your recordsets and connections properly?
Reply With Quote
  #3  
Old 11-17-2007, 11:17 PM
Lobsang Lobsang is offline
Member
 
Join Date: Mar 2002
Location: Douglas, Isle of Man
Posts: 18,213
Quote:
Originally Posted by ZipperJJ
Are you closing/destroying your recordsets and connections properly?
yes. with the .close function

And then setting it to 'nothing'

It's the same code as was on the other server. But for some reason it behaves differently with the access db
Reply With Quote
  #4  
Old 11-18-2007, 04:10 PM
ZipperJJ ZipperJJ is offline
And Finn The Human
Charter Member
 
Join Date: Aug 2001
Location: Northeast Ohio
Posts: 18,814
Try giving IUSR_ALPHA (which usually has a friendly name of "Internet Guest Account" or something "Full Control" NTFS permissions.

IIRC the "Read/Write/Execute" is just IIS perms. You need NTFS which has perms like Read, Write, Delete, Modify...and you might be getting caught up on Modify.

Browse to the directory using Explorer (not IIS) and right-click on the DB or the DB's folder, choose the "Security" tab and you'll see the perms there.
Reply With Quote
Reply



Bookmarks

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


All times are GMT -5. The time now is 07:12 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.

Send questions for Cecil Adams to: cecil@chicagoreader.com

Send comments about this website to: webmaster@straightdope.com

Terms of Use / Privacy Policy

Advertise on the Straight Dope!
(Your direct line to thousands of the smartest, hippest people on the planet, plus a few total dipsticks.)

Publishers - interested in subscribing to the Straight Dope?
Write to: sdsubscriptions@chicagoreader.com.

Copyright 2013 Sun-Times Media, LLC.