locked
Not enough space on temporaly disk RRS feed

  • Question

  • User-453755171 posted

    (sorry for my bad english :-)

    I use again for an old website ASP and a connection to Access database.

    For some reaseons, when I think this website get to many connexions I have a message that look like this :

    "Not enough space on temporaly disck"

    end the error link in the code off my page wher theris is the data conexon :

    Set Conn = Server.CreateObject("ADODB.Connection")
    connstring = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & mapPathFpdb &"/mybase.mdb"
    >>> (here) Conn.Open connstring

    Is a quota existe in a Pool in IIS for my website ?

    Thank all

    Wednesday, November 7, 2018 1:58 PM

All replies

  • User-72702933 posted

    Hi Frankdelyon,

    "Not enough space on temporaly disck"

    end the error link in the code off my page wher theris is the data conexon :

    Set Conn = Server.CreateObject("ADODB.Connection")
    connstring = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & mapPathFpdb &"/mybase.mdb"
    >>> (here) Conn.Open connstring

    Is a quota existe in a Pool in IIS for my website ?

    As far as I know, this is a generic error when using Access databases.

    Causes for this error are:

    1) connecting to the Access database using odbc instead of using the more reliable OLEDB JET driver.

    2) running an extreamly large query, which Access can not deal with.

    I guess your query is very large,  Access (Jet) uses the tempfile if necessary to store interim query results.

     You can try increasing the swap file size on the computer, but you should consider modifying your query string to avoid very large query.

    More details about how to increase the swap file size, you could refer to below article:

    https://superuser.com/a/793325 

    Best Regards,

    Brando

    Thursday, November 8, 2018 6:29 AM