Active Server Pages error 'ASP 0115'

Discussion in 'Classic ASP' started by bpnoel, Sep 15, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I wrote very simple classic asp script that connects to a MS Access DB and retrives all of the contents of a table as an array. The script works fine for awhile and then I get this error:

    Active Server Pages error 'ASP 0115'



    Unexpected error


    /registration/pitspace/Pitspace.asp


    A trappable error (C0000005) occurred in an external object. The script cannot continue running.





    I can recycle the application pool from the IIS control panel provided by Discountasp.net, and it begins to work again, but a few minutes later I'll get the same error.


    Here's the script I use to gather the data from the DB:


    <%
    Dim strDBPath
    Dim CONN_STRING
    Dim arrDBData
    Dim rstGetRows
    Dim cnnGetRows
    Dim isVendor
    Dim strSQL
    strDBPath = Server.MapPath("/fpdb/PKRA_PitSpace.mdb")
    CONN_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp; strDBPath &amp; ";"
    set cnnGetRows = Server.CreateObject("ADODB.Connection")
    cnnGetRows.Open CONN_STRING
    Set rstGetRows =Server.CreateObject("ADODB.Recordset")
    rstGetRows.open "SELECT * FROM PitSpace",CONN_STRING,adOpenKeyset, adLockOptimistic, adCmdText
    arrDBData = rstGetRows.GetRows()
    rstGetRows.Close
    Set rstGetRows = Nothing
    cnnGetRows.Close
    Set cnnGetRows = Nothing
    %>


    Anyone have any ideas on this one?


    Thanks in advance.
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    This is one of those weird MS Access error.


    Is your database very big or you have many opened connections? MS Access tend to go crazy if the DB is big or your application opens a lot of connections to it.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page