Problem with running script locally

[dommett]

HELP! I installed a classified ads script on my local machine, customized its colors, etc, then installed on my live hosted website. The live site is still running fine but I found my local version is no longer runable. I have reinstalled Win XP Pro since I last worked on it locally so I figure I have a permissions issue or IIS issue somewhere but can not find it. Of course this is not my area of expertise. I know the software script is fine (worked locally before and is still working on live site). I did a reverse publish to get the most recent version to my local IIS but still no success. I have gone back to the basics and have some really dumb questions:

1) With the script, I was told to set permissions for various folders. For what user do they mean? I assume it would be for IUSR or Administrator.
2) When I go to look at setting the permissions, I see a user that starts with OWS - I've been looking online to figure out what this is but have only found a brief mention that it might be related to Frontpage Server Extentions? Is this right and should I leave it alone?
3) I opened up full permissions to Administer and IUSR. When I start the script, it opens an access database to delete some old entries in a table. I see a .ldb file show up in the database directory and then the script hangs and the .ldb file never goes away. If I have the permissions trimmed back, I get another error. I'll paste that error later.

Any suggestions on things to check? try?
Thanks,
Dommett

 

[dommett]

Here is the error I get when I have permissions set for both Administrator and IUSR accounts:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft JET Database Engine (0x80004005)
Could not delete from specified tables.
/XeniaShopper/classifieds/conn.asp, line 68


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)

Page:
GET /XeniaShopper/classifieds/default.asp


The line it is faulting out on is:
Set rsDeleteConn = MM_conn_STRING.execute(SQLExp)

Like I said before this script works - this is a local setting problem.

 

[Tarwn]

Double check that the tables exist, etc.
Double check the permissions for the actual database file to make sure it isn;t set to read-only or somehting like that.

-T

 

[dommett]

Tables are there and I did check the actual database permissions. Even gave it full control - still no luck.
Thanks,
Dommett

 

[Tarwn]

http://support.microsoft.com/kb/240098

I ran into this article, not sure if it applies but it is an official MS article (which means it only has about a 5% chance of applying since they tend to recycle error messages)

-T

 

[dommett]

I'm not too concerned about the script itself - I know it works. This is a local machine set up issue.

I just installed a fresh new Win XP pro drive with service pack 2 and with the .net framework 1.1. Now, in Firefox when I go to open the classfieieds/default.asp file I get this pop-up window saying:

You have chosen to open
default.asp
which is a: ASP file
from

http://d2/xeniahopper/classifieds/

What should Firefox do with the file?

and the only option for me to pick is to 'Save to Disk'.

I don't get that pop-up when I try other default.asp files (

http://d2/xeniashopper/forum/default.asp)

within my website. What am I missing here?

Desperate for help!
Dommett

 

[dommett]

Never mind last post concerning downloading the .asp file. I had a custom error 500;100 set to a file not the correct url.

I am back to getting the JET database Engine eroor:Could not delete from specified tables.

and again - I know the script is fine. This has to be a system issue.