How do avoid time out expired in my VB 2008 aplication
Posted on 2011-03-23
I have a form where I call a lot of stored procedures in a MySQL database. In the procedures are same queries which execute updates, insert into etc.
Sometimes, during debugging, depending on the size of tables included in the queries, the program stops and appears the message below:
"The CLR has been unable to transition from COM context 0x1b0f58 to COM
context 0x1b10c8 for 60 seconds. The thread that owns the destination
context/apartment is most likely either doing a non pumping wait or
processing a very long running operation without pumping Windows
messages. This situation generally has a negative performance impact and
may even lead to the application becoming non responsive or memory usage
accumulating continually over time. To avoid this problem, all single
threaded apartment (STA) threads should use pumping wait primitives
(such as CoWaitForMultipleHandles) and routinely pump messages during
long running operations."
In the site there is a solution in C#, but I would like a solution for VB2008.
I Would like to Know if it is possible a solution by creating a new thread.