links to asp pages are not connecting

[brad10]

Urgent assistance required as part of the site is down....

A text string has been input into a date/time field in an access database via an asp page. This has now messed up all asp pages that connect to that database. None of the links to asp pages work as a result of this.

Can anyone tell me how I can get these up and running again?

I have changed the field in the database back to a text field. But it seems like I still need to debug somehow but I'm not sure what needs doing. Can anyone help?

 

[FengShui1998]

brad10.

You can open the database and do a replace straight from the application.

1. Double click on the ACCESS database file name to open it.
2. Highlight the targettable and double click on the box next to the name to open the table.
3. Click on the column header to highlight the whole column.
4. At the top of the application, go to "Edit", "Replace", click on the "Replace" tab.
5. For "Find what:" , type the string to replace
6. For "Replace with:", enter a new date
7. For "Look in:, make sure the correct column has been selected.
8. For "Match:", choose "Any part of field".
9. Hit the button "Replace All" until you get the window: "Microsoft Access finished..."
10. Hit cancel to close the window.
11. Go to "Save" to savew your results.


fengshui_1998

 

[brad10]

fengshui_1998,

Thanks for the help (I need it!) but I wasn't clear enough before - the text (which was actually the word 'text') was input via the asp page but never made it to the date/time field that it was bound to in the database due to the conflict of field types. The page just froze for ages and then gave an internal server error message. I looked in the database and that record was never added.

No asp pages that connect to the database work as a result of this - which means several parts of the site are down.

Anymore advice fengshui_1998? or can anyone help me please -I'm really stuck and need urgent assistance.

 

[FengShui1998]

brad10,

I guess I'm a little confused. If 'text' was a part of the field that was in the input but never made it to the database your web site should still be running. Each web page should be stateless and no other processes should be affected by an errant input.

If you're having trouble, you can go to the Internet Services Manager, from Start --> Settings --> Administraion Tools. Here you can stop your web site and re-start it.

Check your web page after that. Also, I would check to see if any web pages are working. If your web pages are working then there might be something wrong with the database.

Good luck.
fengshui_1998

 

[brad10]

fengshui_1998,

I think it must be something to do with the database as all other pages work (just asp pages trying to connect to this database that wont).

Does anyone have any clues?

 

[brad10]

Looking at the database I'm not so sure - The database seems to be running ok. I think that the server has been affected by an erroneous entry.

Can anyone give me some pointers as to what I should be checking on the server - or should I go onto the server forum? It's as though the server needs debugging somehow to clear this error before it'll serve these pages. Like I said the rest of the site is running ok.

Help!

 

[FengShui1998]

brad10,

Since no records have been written to the database,

have you tested your connection? Has your password changed? Has your account changed? Was it working before?

fengshui_1998

 

[brad10]

fengshui_1998

Thanks for hanging in with this -
<<have you tested your connection?>> Yes the connection is working fine.
<<Has your password changed? Has your account changed?> No account details have changed as far as I'm aware.

<<Was it working before?>> Yes, everything was fine up until Friday afternoon.

When the problem started I accessed the server remotely and there was a pop up box asking me if I wanted to debug - Which is why I think all this begun with the erroneous data entry. I think I just cancelled this box.

I've checked all the server settings and everything seems ok and as it was before the problems???

The server won't process any .asp files now - even ones that are connected to different databases. Could it have corrupted the asp.dll?

 

[FengShui1998]

brad10,

Have you tried using a simple ASP page like:

<html>
<body>

<%

response.write &quot;This is a test&quot;

%>

</body>
</html>

I can't believe it will not work with simple ASP. pages. Have you checked to see if a file .ASP is associated with another app?

fengshui_!998

 

[brad10]

fengshui_1998

I've tried the simple asp page and it just gives the same error - this page cannot be displayed
HTTP 500 - Internal server error
Internet Explorer

What do you mean by your last statement - re another app?

 

[FengShui1998]

brad10,

What I meant was, is a file with a .ASP extension associated with another application like NOTEPAD.

Your situation is odd since you cannot open ANY asp pages. I do not think its your databases. Do you have control of the web server or does somebody else? Are there any other apps that concurrently run on that server like Exchange, SQL , etc? Has file protections been changed on .ASP files since you can browse HTML but not ASP files?

fengshui_1998