Thanks Clay, It's definitely Starteam - I used FileMonitor from SysInternals to identify it.
My database is running on a removable drive, which may be the cause I guess. If it gets temporarily disconnected or something (or this is usually displayed on the screen). You are right in the last paragraph, that as Starteam is not even interested in the file, it is unlikely to be the cause, although empirical evidence suggests otherwise. I shall keep investigating. Thanks for the help. Regards, Steve -----Original Message----- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 9:42 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Unable to open database file Drew, Stephen said: > Yet Starteam (version control system) is still interfering with the > file > - causing unexpected errors while the application is running. Is this > because the locking in Windows is below-par in comparison with the > Unix locking? The thing is that Starteam is not even interested in > the file, only the directory (I guess it is scanning the file to check > it's not been added to version control). First, verify that it's really StarTeam touching the process and fouling it up. You might also want to make sure that you're only using timestamps and not md5 sums to verify file integrity. Trust me, as a fellow StarTeam victim, that using md5 sums in StarTeam is not a reliable way to determine file changes (having nothing to do with md5 and everything to do with StarTeam). Second, check if this thing is running on a local or network drive. SQLite isn't recommended for network drives, and StarTeam most assuredly isn't suitable for network drives. The truth is that StarTeam probably isn't causing the problem, since it isn't interested in writing to the file. If it is causing the problem, consider one of the free source control systems. I've found CVS at least to be a lot less problematic than StarTeam. Clay -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development
