Hello, I have a database file placed onto a NTFS LAN based local server. Application's on different machines tries to access this database file and update it frequently.
I am using Christian Werner's ODBC Driver. I am facing "Database is locked" problem. * Is concurrency weak in SQlite? * Doesn't the lock get cleared when the application that locked it crashes? * How do I explicitly clear the database from lock? * What is the full fledge solution for "database is locked"? Any precaution's to be taken for multiple access to the database file? Thanks, Gaurav