how to solve this error in multithreading " A first chance exception of type 'System.Data.Odbc.OdbcException' occurred in System.Data.dll" in output window

Question

I make 10 thread in that i am going to save record to mysql and change continuesly value and  save repeatedlly but i got as following msg in output window .

"A first chance exception of type 'System.Data.Odbc.OdbcException' occurred in System.Data.dll"

and some of threads are automatically ignored or aborted  what ever happen but only 4 to 5 thread isalive at last

I am new in threading so plz help me out on this

This occur when i use more than 4 thread .

Answer 1

Hi,
You have a concurrency bug, you have to use different connections to run that in parallel, one connection per thread.
The reason it crashes with exactly more than 4 is arbitrary and depends on system settings (number of cores) and load.

Regards,
Hugo