asp classic app moved to IIS 6 slow/failing

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Guest's Avatar

    asp classic app moved to IIS 6 slow/failing

    Hi All,

    I have several classic asp pages in site that were originally programmed
    with Visual Interdev (or Visual Web Developer Alpha... remember that?). The
    pages use the Script Library objects for Recordset and Data Grid
    functionality. The database is an Access mdb file that we connect to.

    The app was recently moved from a Windows 2000, IIS 5 server to a Windows
    2003 IIS 6 server. The permissions, database connections info etc was
    duplicated on the new server. The application works... However, the database
    access/grid page will occasionally work, but most often now takes so long to
    process that we receive a timeout in the app. We have not changed the
    programming, and on some occasions the page will execute quickly. It seems
    that the first accesses of the page can be quick, but subsequent requests
    can slow down so much we get the timeout, and this plain english (default
    error I think):

    "An error occurred on the server when processing the URL. Please contact the
    system administrator."

    In the IIS log file for the site, it includes the following error for the
    post request:

    POST /search_dir/Default.asp |-|ASP_0113|Scrip t_timed_out 80

    Does anyone have any ideas on what could be choking the asp/MS Access
    application.

    K Waldron


  • Jon Paal

    #2
    Re: asp classic app moved to IIS 6 slow/failing

    I had a similar experience with one of my websites.

    Unfortunately, I never was able to resolve it and had to have the site moved back onto a server with IIS 5, where it worked again.

    IIS6 has a setting somewhere which affects the volume of Access database usage.



    <waldo@htl.netw rote in message news:uheVdZ23GH A.1848@TK2MSFTN GP06.phx.gbl...
    Hi All,
    >
    I have several classic asp pages in site that were originally programmed with Visual Interdev (or Visual Web Developer Alpha...
    remember that?). The pages use the Script Library objects for Recordset and Data Grid functionality. The database is an Access mdb
    file that we connect to.
    >
    The app was recently moved from a Windows 2000, IIS 5 server to a Windows 2003 IIS 6 server. The permissions, database connections
    info etc was duplicated on the new server. The application works... However, the database access/grid page will occasionally work,
    but most often now takes so long to process that we receive a timeout in the app. We have not changed the programming, and on some
    occasions the page will execute quickly. It seems that the first accesses of the page can be quick, but subsequent requests can
    slow down so much we get the timeout, and this plain english (default error I think):
    >
    "An error occurred on the server when processing the URL. Please contact the system administrator."
    >
    In the IIS log file for the site, it includes the following error for the post request:
    >
    POST /search_dir/Default.asp |-|ASP_0113|Scrip t_timed_out 80
    >
    Does anyone have any ideas on what could be choking the asp/MS Access application.
    >
    K Waldron
    >

    Comment

    • Jon Paal

      #3
      Re: asp classic app moved to IIS 6 slow/failing

      I had a similar problem with one of my customers websites. Worked fine for years until the webhost upgraded to IIS6, then it
      consistently failed on busy days.

      Apparently IIS6 has a usage limitation on Access databases which can cripple the websites.

      My only solution was to have the website moved back onto a server with IIS5 where it worked fine again.


      <waldo@htl.netw rote in message news:uheVdZ23GH A.1848@TK2MSFTN GP06.phx.gbl...
      Hi All,
      >
      I have several classic asp pages in site that were originally programmed with Visual Interdev (or Visual Web Developer Alpha...
      remember that?). The pages use the Script Library objects for Recordset and Data Grid functionality. The database is an Access mdb
      file that we connect to.
      >
      The app was recently moved from a Windows 2000, IIS 5 server to a Windows 2003 IIS 6 server. The permissions, database connections
      info etc was duplicated on the new server. The application works... However, the database access/grid page will occasionally work,
      but most often now takes so long to process that we receive a timeout in the app. We have not changed the programming, and on some
      occasions the page will execute quickly. It seems that the first accesses of the page can be quick, but subsequent requests can
      slow down so much we get the timeout, and this plain english (default error I think):
      >
      "An error occurred on the server when processing the URL. Please contact the system administrator."
      >
      In the IIS log file for the site, it includes the following error for the post request:
      >
      POST /search_dir/Default.asp |-|ASP_0113|Scrip t_timed_out 80
      >
      Does anyone have any ideas on what could be choking the asp/MS Access application.
      >
      K Waldron
      >

      Comment

      • Hossam Salah

        #4
        Re: asp classic app moved to IIS 6 slow/failing

        I also have this problem, any one have a solution that works, my server is
        2003 server SP1 with the latest fixes.

        Thank you



        <waldo@htl.netw rote in message
        news:uheVdZ23GH A.1848@TK2MSFTN GP06.phx.gbl...
        Hi All,
        >
        I have several classic asp pages in site that were originally programmed
        with Visual Interdev (or Visual Web Developer Alpha... remember that?).
        The pages use the Script Library objects for Recordset and Data Grid
        functionality. The database is an Access mdb file that we connect to.
        >
        The app was recently moved from a Windows 2000, IIS 5 server to a Windows
        2003 IIS 6 server. The permissions, database connections info etc was
        duplicated on the new server. The application works... However, the
        database access/grid page will occasionally work, but most often now takes
        so long to process that we receive a timeout in the app. We have not
        changed the programming, and on some occasions the page will execute
        quickly. It seems that the first accesses of the page can be quick, but
        subsequent requests can slow down so much we get the timeout, and this
        plain english (default error I think):
        >
        "An error occurred on the server when processing the URL. Please contact
        the system administrator."
        >
        In the IIS log file for the site, it includes the following error for the
        post request:
        >
        POST /search_dir/Default.asp |-|ASP_0113|Scrip t_timed_out 80
        >
        Does anyone have any ideas on what could be choking the asp/MS Access
        application.
        >
        K Waldron
        >

        Comment

        Working...