[Mono-list] MySQL Connector Problems

[David P. Donahue]

I just upgraded to the latest MySQL .NET Connector (1.0.7) in the hopes 
of resolving these issues, but no luck.  For reference, I'm using the 
Mono 1.0 build since my .NET web app is being hosted on Mono 1.1.9.

There doesn't seem to be a pattern, but a lot of times one of two errors 
will happen when I try to bind a DataSet to a SELECT statement:  Either 
nothing at all will be returned (not even an empty schema for the table) 
or it will tell me that the SELECT would examine more rows than 
MAX_JOIN_SIZE.

In either case, I can manually run the query on the server and it 
executes just fine (and quickly enough that I have a hard time believing 
the latter of the two errors).

Does anyone know (or have an idea) why this might be happening?  For 
reference, my function that does the data binding code looks like this:

mySqlConnection = new MySqlConnection(stringDatabaseConnection);
mySqlDataAdapter = new MySqlDataAdapter(stringSelect, mySqlConnection);
dataSetSQL = new DataSet();
mySqlDataAdapter.Fill(dataSetSQL);
return dataSetSQL;



Regards,
David P. Donahue
ddonahue at ccs.neu.edu
http://www.cyber0ne.com