RE: [sqlite] Write issues on some computers?
What if the database was not closed properly on exit, would that be enough to set the database to read-only? Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: February 24, 2005 11:43 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Write issues on some computers? Luc Vandal said: > Today a user told me that everything was fine yesterday and since today he > can't write to the database. What could cause that? The software closes > the > database on exit. I guess that the db is busy but what could cause the db > to > be busy for a large amount of time? You might want to ship him an updated program that reports the actual error. Making assumptions is dangerous, especially since there are multiple viable options for why he can't get in. Clay -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development ---
RE: [sqlite] Write issues on some computers?
Luc Vandal said: > Today a user told me that everything was fine yesterday and since today he > can't write to the database. What could cause that? The software closes > the > database on exit. I guess that the db is busy but what could cause the db > to > be busy for a large amount of time? You might want to ship him an updated program that reports the actual error. Making assumptions is dangerous, especially since there are multiple viable options for why he can't get in. Clay -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development
Re: [sqlite] Write issues on some computers?
Luc, Luc Vandal said: The database is stored in the [User]\Local Settings\Application Data\ folder for the current user. Forgive my ignorance of Windows user directories, but could it be that some of these users are keeping their [User] folder on a network drive? That is sometimes reported to be a bad idea for keeping SQLite databases. Just a thought. Ulrik Petersen -- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark
RE: [sqlite] Write issues on some computers?
Luc Vandal said: > The database is stored in the [User]\Local Settings\Application Data\ > folder > for the current user. In that case it's worth looking at the folder and the file and making sure that both have write permission for the user in question. This isn't terribly easy to do if your users are remote, but if you have a copy in house that is misbehaving you should be able to get at it. Just remember to clear the Simple Sharing option so that you can see the full permissions and ACL for files and folders. Try installing it on a machine in house as an administrator and then running it as an unprivileged or restricted user. It still sounds like some of the deployment issues that I've run into. They're no fun at all, especially since you get to look foolish in front of your customers. Clay -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development
RE: [sqlite] Write issues on some computers?
Hello Clay, The database is stored in the [User]\Local Settings\Application Data\ folder for the current user. Thanks for your help! Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: February 23, 2005 11:50 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Write issues on some computers? Luc Vandal said: > I don't know if it's SQLite related, but some of our users are complaining > that they can't write to the database. On our side everything is fine. > That > is the case with most users. But for some the SQLite db just seems to > malfunction. Is there something (a dll, a windows settings, etc.) that > could > cause this? File permissions issues could cause this. This is particularly easy to happen if the application was installed by a different user than the one running it. For instance on my Windows system at home, I always run under my personal, non-administrative account. I obviously install software as an administrative account. If the application database resides in a folder that isn't owned by the calling user, or that the user doesn't have write access to, you get an error when writing. This could happen, for instance, if you store your database under "c:\program files\yourapp" This issue isn't specific to Windows; I get the same problem installingon UNIX systems if I foul up the permissions. If possible I strongly recommend storing the database in a user-specific folder, such as Application Data under windows or your app's folder under their home directory. I spent a lot of time beating my head against the wall over this same issue, so hopefully my pain will save you some. Clay Dowling -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development ---
Re: [sqlite] Write issues on some computers?
Luc Vandal said: > I don't know if it's SQLite related, but some of our users are complaining > that they can't write to the database. On our side everything is fine. > That > is the case with most users. But for some the SQLite db just seems to > malfunction. Is there something (a dll, a windows settings, etc.) that > could > cause this? File permissions issues could cause this. This is particularly easy to happen if the application was installed by a different user than the one running it. For instance on my Windows system at home, I always run under my personal, non-administrative account. I obviously install software as an administrative account. If the application database resides in a folder that isn't owned by the calling user, or that the user doesn't have write access to, you get an error when writing. This could happen, for instance, if you store your database under "c:\program files\yourapp" This issue isn't specific to Windows; I get the same problem installingon UNIX systems if I foul up the permissions. If possible I strongly recommend storing the database in a user-specific folder, such as Application Data under windows or your app's folder under their home directory. I spent a lot of time beating my head against the wall over this same issue, so hopefully my pain will save you some. Clay Dowling -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development
RE: [sqlite] Write issues on some computers?
Could the problem be MSVCRT.DLL? Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com -Original Message- From: Luc Vandal [mailto:[EMAIL PROTECTED] Sent: February 23, 2005 9:12 AM To: sqlite-users@sqlite.org Subject: [sqlite] Write issues on some computers? Hi, I don't know if it's SQLite related, but some of our users are complaining that they can't write to the database. On our side everything is fine. That is the case with most users. But for some the SQLite db just seems to malfunction. Is there something (a dll, a windows settings, etc.) that could cause this? I really can't see what in our code would cause that. Are there some requirements for SQLite? Thanks, Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com
[sqlite] Write issues on some computers?
Hi, I don't know if it's SQLite related, but some of our users are complaining that they can't write to the database. On our side everything is fine. That is the case with most users. But for some the SQLite db just seems to malfunction. Is there something (a dll, a windows settings, etc.) that could cause this? I really can't see what in our code would cause that. Are there some requirements for SQLite? Thanks, Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com
