Thanks for the response. I have finally been able to look at the system where this is running. You are correct. They are on an older system (2.8.17). I'll try to get them to update.
They are using 3 different databases. When I issue a .databases command I see that all three are using the same temporary database. Is it possible they could be bumping heads? When issuing PRAGMAS, do they have to be issued from sqlite executable or can they also be issued via the Tcl API? Thanks -----Original Message----- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 05, 2007 2:35 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] unable to open a temporary database file for storing temporary tables Regarding the DOS-like name, it may be the canonical name on Windows for FAT/VFAT file systems. Is that what you're using? I wonder if there's a hash collision in trying to get the file name down to DOS 8.3 file name format. Do you have many sqlite_* files in that directory? Since the file prefix is sqlite_ instead of etilqs_, you must be using an older sqlite release. A newer version may have solved the problem. Some guesses: Do you have sufficient space and/or privileges in that directory? Is some anti-virus program running doing some crazy stuff like locking directories or temporarily filling up Temp? Is there a limit on the number of files in a directory on Windows? --- Charlie Bursell <[EMAIL PROTECTED]> wrote: > I have seen the error "malformed database schema - unable to open a > temporary database file for storing temporary tables" discussed in > another thread relative to PHP and BSD Unix. However, I am having this > problem on Windows 2003 using the Tcl API. > > If I run the .databases command, I see something like: > > C:\DOCUME~1\charlie\LOCALS~1\Temp\sqlite_PfaaLBX02TU6g9w > > Is the DOS like path statement a problem? > > The application runs fine for a few days but then gets the above error. > Shutting everything down and restarting seems to clear it for a whle. > > Would periodically clearing the cache help? ________________________________________________________________________ ____________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
