DevArt ODBC drivers - DB file lock issue
Posted: Wed 19 May 2021 12:27
Hello All,
We are using DevArt ODBC drivers for accessing SQLite DB using .Net ODBC library.
However, when the data is inserted in the DB, the DB file remains locked for some time (approx. 2-3 minutes) even though the DB connection is closed. This is creating problems for us.
Is there any way to release the lock immediately after closing the DB connection? Any help would be greatly appreciated.
Regards,
Nitin
We are using DevArt ODBC drivers for accessing SQLite DB using .Net ODBC library.
However, when the data is inserted in the DB, the DB file remains locked for some time (approx. 2-3 minutes) even though the DB connection is closed. This is creating problems for us.
Is there any way to release the lock immediately after closing the DB connection? Any help would be greatly appreciated.
Regards,
Nitin