|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Why does IIS 6.0 need to wait 1 minute between each asp-page being displayed?
I have some dynamic (asp) and static web pages. I have run these pages on Win xp pro's IIS 5.0 earlier so I know that the code is (atleast somewhat) ok.
Now I have installed win 2k3 server and started the IIS 6.0 service. I try to run IIS as a local test server before putting the pages online. The issue here is that all my pages are displayed without problems for a while, but after some minutes I get the following error message, everytime I want to view a dynamic asp page (if I choose a static page instead it will always be displayed, without exceptions). "There is a problem with the page you are trying to reach and it cannot be displayed". "HTTP 500 Internal Server Error, Internet Explorer". If I wait between 1.00-1.05 minutes however, the asp page will be displayed one time. If I want to go to another asp page, the same error is displayed again (same problem also if I use the back arrow in the browser and click the same link once more) and I will have to wait precisely one minute more...and this loop goes on forever. IIS can only process one request for asp-pages per minute, not very good. However if I wait say 5 minutes instead of 1 the server will run ok for yet another while and I can click many asp links. It is like the server must rest before processing anymore requests... Hope you can help me out here, because I am confused... |
|
#2
|
||||
|
||||
|
have you turned off 'friendly error messages' to see if you get a more descirptive error?
__________________
Come JOIN the party!!! Quote of the Month: Retirement: Because you've given so much of yourself to the company that you don't have anything left we can use. Questions to Ponder: What do you do when you see an endangered animal eating an endangered plant? iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm") copyright© 2008 sbenj69 |
|
#3
|
|||
|
|||
|
Thank you for your reply!
I have turned of 'friendly error messages' and received a "very informative": "Provider error 80004005 Unspecified error". The row in my code that the error points at is always the one where I write "con.open" (to open the Access database). Could there be any compatibility issues between Windows Server 2003/IIS 6.0 and Access 2003? Hope you can help me out here because this "unspecified error" is driving me crazy... |
|
#5
|
|||
|
|||
|
At the moment I use this code:
Code:
Dim con
Set con = server.CreateObject("ADODB.connection")
con.open "databaseDSN"
I have of course gone into the administrative tools, chosen ODBC and created a system DSN with the correct information entered (Access driver). I get intermittent contact with the database and sometimes the info from the database is displayed. However, there must be some kind of problem with the connection since the error points to the con.open "databaseDSN" line. If I want to substitute my current connection string for something else. How then should the code be written in my case and where in the overall code should it be placed (I have the database called dbase.mdb in the "C:\Inetpub\wwwroot\intranet\connections" folder)? Code:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"
|
|
#6
|
|||
|
|||
|
Try using a Jet OLEDB provider connection string. You can't do that through a DSN, but there a plenty of samples at the link micky provided you.
W2003 IIS and Access is less stable than previous IIS versions. I know when my hosting company upgraded all their servers to W2003 there were more issues with sites using Access db's than anything else.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain |
![]() |
| Viewing: ASP Free Forums > System Administration > Microsoft IIS > Why does IIS 6.0 need to wait 1 minute between each asp-page being displayed? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|