Strange ODBC Error

Results 1 to 2 of 2

Thread: Strange ODBC Error

  1. #1 Guest

    Default Strange ODBC Error

    I recieve the following ODBC error from a script I wrote:<BR><BR>[Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk.<BR><BR>The script takes 100 or so rows from a db, creates a unique id, inserts them into a new DB, and sends an email to the user with the ID. <BR><BR>This error occurs at the point of the insertion into the new database. And here is the strange part - It only happens after 15-20 inserts. A different number each time.<BR><BR>The hosting company (outside company) swears there are no size restriction on our Web, and the DB itself is relatively small (200K or so). <BR><BR>Any ideas? Suggestions? <BR><BR>Anyone know where I can find some documentation as to what this error means?<BR><BR>Thanks in advace,<BR>William Case<BR>

  2. #2 Guest

    Default RE: Strange ODBC Error

    IT sounds like your ISP needs to increase the size of their Paging File or free up some space on the drive where the Temp files are being written.<BR><BR>A search on MSDN for "Not enough space on temporary disk" revealed the following article:<BR><BR>Not enough space on temporary disk. (Error 3183)<BR>You tried to perform an operation that requires more space than is available on the temporary disk. Your temporary disk location is based on the TEMP DOS environment variable, which was set when your system started.<BR><BR>For example, you may be trying to create a query that creates temporary files larger than the temporary disk. Reduce the size of the temporary files by accessing smaller amounts of data at one time or increase the size of the temporary disk.<BR><BR>You can increase the amount of available temporary disk space in several ways: <BR><BR>Select fewer records. Dynaset-type, forward-only – type, and snapshot-type CdbRecordset objects record keys and data to the temporary disk.<BR><BR><BR>Select a different drive for your temporary disk.<BR><BR><BR>If the temporary disk is a RAM disk, increase the amount of available RAM and the space allocated to the RAM disk, or move it to a fixed disk.<BR><BR><BR>Free some space by deleting data or by removing unneeded tables, queries, forms, macros, and modules from your database.<BR><BR><BR>Free some space by compressing deleted records out of your database.<BR><BR><BR>If you still need additional space, consider removing other unused files from your disk.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts