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
DevArt ODBC drivers - DB file lock issue
Re: DevArt ODBC drivers - DB file lock issue
We have found that the issue is caused by the Connection Pooling option in ODBC Administrator. To disable pooling, open ODBC Administrator, select the 'Connection Pooling' tab, then choose our driver and double-click 'Set Connection Option Attributes'. Select 'Don't pool connections to the driver' and click OK.