Classic ASP

Re: Delay in ASP pages on DSN connection to Access DB

TRU — Fri, 26 Jun 2009 15:15:11 GMT

I will look into your suggestion.

But I think I discovered the problem not related to IIS.

Looks like a had some rougue google analytics code hanging things up. Since we moved the site we are no longer using a SSL. While not 100% sure yet, I think we had some analytics code that was trying to run through SSL that did not exist. This may have been causing the hang. Just no sure why there were times when the cart ran smoothly and others a 20 second delay between each page call.

Since removing the analytics code, the site is lightening quick!

Will give it 24 hours to see if anything gets crazy again.

Regards,

TRU

Re: Delay in ASP pages on DSN connection to Access DB

lextm — Fri, 26 Jun 2009 06:06:53 GMT

Can you upgrade from Access to SQL Server? Below is a white paper on this topic and it states clearly on page 14 that Access isn't designed for the web.

http://download.microsoft.com/download/a/4/7/a47b7b0e-976d-4f49-b15d-f02ade638ebe/SQLAccessWhatsRight.doc

Regards,

Delay in ASP pages on DSN connection to Access DB

TRU — Fri, 26 Jun 2009 00:49:38 GMT

Hoping somebody can help.

I have a 3rd party .asp cart application that we have been running for many years.

We recently moved it from a Win2k IIS5 server manged by another party-- to Win2k3 IIS6 server managed by myself. The application is running from a DSN connection to an Access DB. We are seeing no issues with any other .asp pages in other webs on the server. This appears to be an issue with this specific web only.

Periodially the pages hang. They are consistently hanging for about 20 seconds before the next page of data appears.

No idea where I should even start looking to remedy the problem.

This behavior seems to be random and their does not appear to be any events in the event view specfic to this web.

I believe we had this problem with our previous host which they were able to remedy at the time, but no idea what they did to fix.

Guidance appreciated on where to start troubleshooting.

TRU