« Previous Next »

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

Last post 06-26-2009 11:15 AM by TRU. 2 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (3 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 06-25-2009, 8:49 PM

    • TRU
    • Not Ranked
    • 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
    • Top 10 Contributor
    • Joined on 10-22-2008, 4:18 AM
    • Shanghai, PRC
    • Posts 1,373

    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
    • Not Ranked
    • 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
Page 1 of 1 (3 items)
Microsoft Communities