RE: [sqlite] unable to open a temporary database file for storing temporary tables
Thanks Dan, I'll give it try -Original Message- From: Dan [mailto:[EMAIL PROTECTED] Sent: Thursday, December 06, 2007 5:06 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] unable to open a temporary database file for storing temporary tables > When issuing PRAGMAS, do they have to be issued from sqlite executable > or can they also be issued via the Tcl API? Pragmas can be executed via the Tcl API, because they are a part of SQLite's SQL dialect. Unlike the 'dot-commands' that are only available in the shell tool. Dan. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] unable to open a temporary database file for storing temporary tables
When issuing PRAGMAS, do they have to be issued from sqlite executable or can they also be issued via the Tcl API? Pragmas can be executed via the Tcl API, because they are a part of SQLite's SQL dialect. Unlike the 'dot-commands' that are only available in the shell tool. Dan. - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] unable to open a temporary database file for storing temporary tables
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] -
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] -
[sqlite] unable to open a temporary database file for storing temporary tables
This is my first post. I thought I had osted yesterday but do not see it so forgive me if this is a duplicate. 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? I would appreciate any ideas from this group.