Jump to content
UBot Underground

Recommended Posts

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!!

Link to post
Share on other sites

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.

  • Like 1
Link to post
Share on other sites

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.

Link to post
Share on other sites

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.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...