ASP + MSAccess + IIS 5.1 was working and suddenly stopped! W

Windows Software 5498 This topic was started by Four and Twenty, 2002-01-20 21:15

Discussion 15

1615 Posts
Location -
Joined 2000-03-25

2002-01-20 22:15

I have been rebuilding a website that I made about a year ago. The rebuild is an all asp driven site connected to an ms access database. I pulled the tables and java scripts off of the old page and put it in an ms access database and the whole thing has been working great for about a week. then this morning at like 11:30 i get this error when I use any of the pages that atempt to add or change the values in the database.

___________________________________________________________
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

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

Please try the following:

Click the Refresh button, or try again later.

Open the kindbuds.dns2go.com:81 home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

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

Technical Information (for support personnel)

Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/upcomingedit/process_change.asp, line 86

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)

Page:
POST 184 bytes to /upcomingedit/process_change.asp

POST Data:
eventlocation=Baltimore&eventstartmonth=1&eventstartday=19&eventstartyear=2002&eventendmonth=2&eventendday=24&eventendyear=2002&eventdescription=American+Crafts+Concil+Show%0D%0A%0D%0A

_______________________________________________________________
here is the asp code that accesses the database i will place a ---> on the line 86 that the error is refering to it is when it attempts to delete the record.
-----------------------------------------------------------------

<%
if not Session("pass") = "good" Then
Response.Write "no password = no access"
Response.End
end if

Dim theDatabase,theRecordset

Set theDatabase = InitDatabase("../database.mdb")
Set theRecordset = GetRecordset(theDatabase,"SELECT * FROM upcoming")

eventlocation = Request.Form("eventlocation")

if(eventlocation = "") Then
Response.Write "Fill in all the Feilds, Go Back and Try Again"
Response.End
end if

eventstartmonth = Request.Form("eventstartmonth")

if(eventstartmonth = "") Then
Response.Write "Fill in all the Feilds, Go Back and Try Again"
Response.End
end if

eventstartday = Request.Form("eventstartday")

if(eventstartday = "") Then
Response.Write "Fill in all the Feilds, Go Back and Try Again"
Response.End
end if

eventstartyear = Request.Form("eventstartyear")

if(eventstartyear = "") Then
Response.Write "Fill in all the Feilds, Go Back and Try Again"
Response.End
end if

eventendday = Request.Form("eventendday")

if(eventendday = "") Then
Response.Write "Fill in all the Feilds, Go Back and Try Again"
Response.End
end if

eventendmonth = Request.Form("eventendmonth")

if(eventendmonth = "") Then
Response.Write "Fill in all the Feilds, Go Back and Try Again"
Response.End
end if

eventendyear = Request.Form("eventendyear")

if(eventendyear = "") Then
Response.Write "Fill in all the Feilds, Go Back and Try Again"
Response.End
end if

eventdescription = Request.Form("eventdescription")

if(eventdescription = "") Then
Response.Write "Fill in all the Feilds, Go Back and Try Again"
Response.End
end if

nid = Request.QueryString("id")

if nid = "" Then
Response.Write "Please pass an ID to delete!"
Response.End
End If

sqlstr = "SELECT * FROM upcoming WHERE id = " & nid

Set theDatabase = InitDatabase("../database.mdb")
Set theRecordset = GetRecordset(theDatabase,sqlstr)

' Delete Record here
if Not theRecordset.EOF Then
theRecordset.MoveFirst
--> theRecordset.Delete <----
End If

theRecordset.AddNew
theRecordset.Fields("EventLocation") = eventlocation
theRecordset.Update

theRecordset.Fields("EventStartDay") = eventstartday
theRecordset.Update

theRecordset.Fields("EventStartMonth") = eventstartmonth
theRecordset.Update

theRecordset.Fields("EventStartYear") = eventstartyear
theRecordset.Update

theRecordset.Fields("EventEndDay") = eventendday
theRecordset.Update

theRecordset.Fields("EventEndMonth") = eventendmonth
theRecordset.Update

theRecordset.Fields("EventEndYear") = eventendyear
theRecordset.Update

theRecordset.Fields("EventDescription") = eventdescription
theRecordset.Update
theRecordset.Close
Set theRecordset = Nothing

theDatabase.Close
Set theDatabase = Nothing

Response.Redirect "index.asp"

%>
-----------------------------------------------------------

I have the page hosted at brinkster and it all works there. with exactly the same files except the asp library with the database connection information in it. But as i said the iis was workin perfect on my computer for like a week and then all the sudden i get this error. so i have checked all the directory security and whatnot. whats more non of the database driven sites will run on my computer if they attemp to delete the values in the database. wtf!

clutch do you know what to make of this

100% cpu utilization when using the search feature in XP

mail server recommendations?

Participate on our website and join the conversation

You have already an account on our website? Use the link below to login.

Create a new user account. Registration is free and takes only a few seconds.

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic

Four and Twenty

1615 Posts
Location -
Joined 2000-03-25

#74449

2002-01-20 23:06

i am getting pissed off and when that happens i start thinking about reinstalling windows. I don't understad why it would work then not work

Ektalog

5 Posts
Location -
Joined 2001-07-14

#74450

2002-01-20 23:43

I am in a hurry -- my wife waiting by the car -- right now. Therefore, I have not checked you posting in detail. I'll stop by tonight when I return to see if there is something else I can help with.

Suddenly, this comes to mind as a long. but possible, shot. If using ODBC, data source-DSN should be in system, not user...darn I should have checked more of your posting. Good luck, I'll come back later.

clutch

3857 Posts
Location -
Joined 2000-03-29

#74451

2002-01-21 02:43

A couple of quick things to check. First, for some reason did the database NTFS permissions get switched to "Read Only"? Also, do you have another app using that ODBC connection, or do you have Access itself connected to it at the same time?

Four and Twenty

1615 Posts
Location -
Joined 2000-03-25

#74452

2002-01-21 18:50

it used to work with access opened now it doesn't
i checked to make sure that it is not read only in the database. But this happens with a bunch of other databases that i haven't touched for a long time. any time you try and delete a value out of any database it returns that error.

clutch

3857 Posts
Location -
Joined 2000-03-29

#74453

2002-01-21 21:22

LOL, I thought I was crazy, but I had the same issue. There was something recent that did this, because when I used system DSNs I could connect as many times as I wanted and not get the error, but I can't do that anymore (no bother, as I use SQL 2000 anyway, but kind of annoying). What have you done recently? Have you upgraded to MDAC 2.7? You can get that here:

http://www.microsoft.com/data/download_270RTM.htm

You might have applied a patch recently, so let's see what was done.

Four and Twenty

1615 Posts
Location -
Joined 2000-03-25

#74454

2002-01-21 22:17

nope nothing like that i was sitting there working on my computer then one minute it worked and the next minute it gave the error and has given the error ever since. I am reinstalling right now cause i got too pissed off and i really need to get it to work so i can get some work done.

Four and Twenty

1615 Posts
Location -
Joined 2000-03-25

#74455

2002-01-21 23:38

reinstalling didn't help now i am really confused.

clutch

3857 Posts
Location -
Joined 2000-03-29

#74456

2002-01-22 00:06

If you can, just make the jump to some form of SQL or MSDE 2000 (which comes with Office XP, VS.NET, Visio 2002 and some other programs) as those natively support multiple connections. I experienced the exact same problem you found, but since I only had one DB that was in Access and I was going to upgrade it to MS SQL, I didn't fiddle with it any further. At one time, I could have the site running *and* be able to connect to the DB in Access or Visual Studio to modify the views (queries) for tuning.

Four and Twenty

1615 Posts
Location -
Joined 2000-03-25

#74457

2002-01-23 05:03

how do i make an sql database
i am willing to learn. I just learned asp over the past week. I was using java/css/html which worked ok but was a bit of a management headache. Now with asp i can integrate all the java/css and generate all the pages on the fly from a webeditable database. So if I can just make an sql database just like that and start askin it to do stuff i am all for it.

clutch

3857 Posts
Location -
Joined 2000-03-29

#74458

2002-01-23 06:10

What database application are you using?

Four and Twenty

1615 Posts
Location -
Joined 2000-03-25

#74459

2002-01-23 06:34

access xp

Four and Twenty

1615 Posts
Location -
Joined 2000-03-25

#74460

2002-01-23 06:39

i have office xp and visual studio 6 i need to get me a copy of VS.NET cause i have a site hosted on a .NET beta server and i would like to start using some .NET code asap since i am just getting started i want to learn the latest

clutch

3857 Posts
Location -
Joined 2000-03-29

#74461

2002-01-23 06:55

Well, you can still write the ASPX files in anything (like Notepad), but you still need some sort of database application which you haven't listed yet. Getting VS.NET will not necessarily solve your problem unless you install MSDE 2K from it, or some other SQL DB server app.

Four and Twenty

1615 Posts
Location -
Joined 2000-03-25

#74462

2002-01-23 17:17

so i could get like SQL server? and that would do it?

BTW i got my iis working by adding a workgroup file to access. I think that my problem has something to do with the "_derived" folders that interdev has added to my directories.

clutch

3857 Posts
Location -
Joined 2000-03-29

#74463

2002-01-23 17:57

Ummm, getting (any version of) SQL is similar to getting any application: it *can* do stuff, but you still have to tell it what to do. Most SQL-centric RDBMS run on the concept of an "engine", whereby the server handles incoming requests directly and then gives back the information. Access, on the other hand, is client based and relies on the requesting computer to open the file, ask for the information, and then close out its connection. Each client is also responsible for error checking/transaction handling (and a frequent cause of errors, hence the built-in user count restrictions depending on what you are doing). This type of database is fine for small workgroups and such, and they are typically royalty free when distributed by developers. Now, if you want something that scales well and is *designed* for multiple concurrent connections, then step up to MS SQL, PostgreSQL, MySQL, Oracle, Progress, etc. I use MS SQL, and I am somewhat familiar with Progress since it is what we use for our ERP system. For simplicity, I would try to get one of the MS versions since it sounds like you have access to a MSDN subscription. I use the Enterprise version on the development boxes myself, but any of them should work fine.

As for the Access error, I can't see why it would suddenly need a workgroup file, nor would I use one. But then again, I try to stay away from Access once I am beyond the initial layout phase of a project.