« Previous Next »

• 06-25-2009, 8:49 PM

  TRU Joined on 04-12-2007, 12:07 PM Posts 5

  Delay in ASP pages on DSN connection to Access DB Reply Contact 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

• 06-26-2009, 2:06 AM

  In reply to

  lextm Joined on 10-22-2008, 12:18 AM Shanghai, PRC Posts 1,266

  Re: Delay in ASP pages on DSN connection to Access DB Reply Contact 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, Lex Li Support Engineer at Microsoft --------------------------- This posting is provided "AS IS" with no warranties, and confers no rights.

• 06-26-2009, 11:15 AM

  In reply to

  TRU Joined on 04-12-2007, 12:07 PM Posts 5

  Re: Delay in ASP pages on DSN connection to Access DB Reply Contact 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