Click to See Complete Forum and Search --> : SQLite "concurrent" write


mce
April 18th, 2008, 03:47 AM
Anybody use sqlite for multiple write access? SQLite doesn't support multiple write access by itself, but according to sqlite web site, it is possible to do our own write sync using mutex. However i am not able to get this to work..., the database is throwing exception "Concurrent violation:..." whenever i try to do Update..

I am using sqlite ADO.net

m_mutex.WaitOne();
m_sqliteAdapter.Update(m_Dataset, "TableAnalog");
m_mutex.ReleaseMutex();