Mysql connector - MultipleActiveResultSets issue
Solution 1
I assume MySql connector doesn't support MARS (Multiple active result sets). In such case you cannot use it at more than one place at the same time.
Solution 2
The problem is not solved but I have found a work around.
I removed MultipleActiveResultSets=True;
from the connection string. I then created a list where I saved the data from MySqlDataReader, I then closed the reader and reopen a new one which then I got the rest of the data from the database. Then simply merged the results together in the list.
So yeah, a temp fix.
If someone knows the proper fix then please comment, otherwise I will be using my temp fix.
Thanks guys.
Admin
Updated on June 04, 2022Comments
-
Admin almost 2 years
First off, I have spent hours looking for a fix - maybe I just need another pair of eyes on this problem.
I'm currently coding a c# application for myself(Personal use). Im running the latest MySQL connector library from mysql.com
My connection string is
public string SQLConnection = "Server=localhost;Database=data;Uid=root;Pwd=ascent;charset=utf8;MultipleActiveResultSets=True;";
My issue is regarding
MultipleActiveResultSets=True;
. When this is included in my SQLConnection string the MySQL library is unable to connect. View the pic below to view my findingsfull image: http://i62.tinypic.com/25a57p1.png
When
MultipleActiveResultSets=True;
is removed from the connection string, I get this resultfull image: http://i58.tinypic.com/2useaom.png
I get a successful connection.
The reason for
MultipleActiveResultSets
is because I'm using 2MySqlDataReader
at the same time - This however can't be changed.If anyone knows why this is failing, then please suggest your fix.
My local MySQL server version: 5.6.17