Jaro 6 Posted November 8, 2017 Report Share Posted November 8, 2017 Hi,I have an advanced script with multiple threads and sometimes the need to query my database is overlapping and I get this message when there are 2 simultaneous connections (at least I think it's because of that):"There is already an open DataReader associated with this connection which must be closed first." I will be very grateful for any reply, thanks!! Quote Link to post Share on other sites
HelloInsomnia 1103 Posted November 9, 2017 Report Share Posted November 9, 2017 You can use Heopas plugin for locking a thread: http://network.ubotstudio.com/forum/index.php/topic/20002-free-heopas-custom-plugin-thread-lock-sqlite-thread-variables-email-ini-clipboard/ Just lock it, perform the database query and unlock and the next thread will be let in. 1 Quote Link to post Share on other sites
Jaro 6 Posted November 9, 2017 Author Report Share Posted November 9, 2017 Wow, thank you soo much HelloInsomnia, I had no idea that there's such a great plugin! Quote Link to post Share on other sites
whoami 26 Posted November 15, 2017 Report Share Posted November 15, 2017 You can use Heopas plugin for locking a thread: http://network.ubotstudio.com/forum/index.php/topic/20002-free-heopas-custom-plugin-thread-lock-sqlite-thread-variables-email-ini-clipboard/ Just lock it, perform the database query and unlock and the next thread will be let in. That is a nice plugin, I was using Aymens SQLite but with Heopas plugin is enough for doing queries on SQLite and free. Quote Link to post Share on other sites
Jaro 6 Posted November 15, 2017 Author Report Share Posted November 15, 2017 I actually don't use SQLite at all just normal database commands with Heopas now..What is the advantage of using the SQLIte plugin? Quote Link to post Share on other sites
HelloInsomnia 1103 Posted November 15, 2017 Report Share Posted November 15, 2017 I actually don't use SQLite at all just normal database commands with Heopas now..What is the advantage of using the SQLIte plugin? You can have a local database this way stored in a file on your computer without needing anything extra installed/running. Quote Link to post Share on other sites
Jaro 6 Posted November 15, 2017 Author Report Share Posted November 15, 2017 Ok, thank you! Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.