Skip to main content
A
Anonymous
April 2, 2007
Answered

Not enough space on temporary disk error

  • April 2, 2007
  • 3 replies
  • 5678 views
Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary
disk. I am running CF MX 7 on Win2k3.

The only fix so far is to restart all the CF processes and flush the Caching in Server settings in CFMX 7. Anyone have an idea what is wrong?

Here is the error on all my webpages that execute a database query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk.
    This topic has been closed for replies.
    Correct answer
    Hi there,

    I do agree with this http://support.microsoft.com/kb/165041/en-us here. I have done this before and amended my registry settings. I have done this last year on the same server that is gave me this issue today. But this time I flushed the Cache in CFMX 7 which sorted it out. Is there a logical explanation as to why it worked as opposed to updating the registry?

    I might sound pedantic about this but just looking for answers. :)

    3 replies

    E
    edbrendel
    Participating Frequently
    April 2, 2007
    I totally understand your wish to get to the bottom of this! There are a lot of factors that can be contributing to the problem - the query itself, the number of users hitting the query, and the tmp files internal to Access.

    Make sure your query isn't returning very large recordsets (e.g. all sales for all salespersons for all year.....). Even a query with a moderate recordset return , hit by a large number of users, can cause this sort of problem.

    If you must use Access in production (which is NOT recommended) your datasource settings should include:

    Maintain connections across client requests be unchecked.

    Limit Connections be checked and Restrict connections to be set to 1

    These settings should help prevent performance issues.

    E
    edbrendel
    Participating Frequently
    April 2, 2007
    This is an issue with Access, not ColdFusion. These links should be helpful:

    http://www.aspfaq.com/show.asp?id=2301

    http://www.mcse.ms/message1584591.html

    http://support.microsoft.com/kb/165041/en-us



    A
    Anonymous
    Correct answer
    April 2, 2007
    Hi there,

    I do agree with this http://support.microsoft.com/kb/165041/en-us here. I have done this before and amended my registry settings. I have done this last year on the same server that is gave me this issue today. But this time I flushed the Cache in CFMX 7 which sorted it out. Is there a logical explanation as to why it worked as opposed to updating the registry?

    I might sound pedantic about this but just looking for answers. :)
    R
    rmorgan
    Inspiring
    April 2, 2007
    I have to ask the obvious, have you checked the obvious? Have you checked to see how much room you have left on the drive(s) that the db resides on? How much ram is free?
    A
    Anonymous
    April 2, 2007
    Yes that is all fine. I did however do the following to resolve the problem. in CFMX 7 Administrator under Server Settings there is a menu for Caching, I just flushed the cache. That summarily has resolved the issue. But that doesnt seem to be an answer for me. There must be some tangible reasoning behind why this has occurred.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices