DevArt ODBC drivers - DB file lock issue

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
nitinkumar
Posts: 1
Joined: Wed 19 May 2021 12:21

DevArt ODBC drivers - DB file lock issue

Post by nitinkumar » 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

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: DevArt ODBC drivers - DB file lock issue

Post by MaximG » Tue 01 Jun 2021 15:32

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.

Post Reply