I'm using MySqldirect version 4.25 with .net 2.0 and LLBLv. 2.5. The problem I'm having is that when I issue a query via LLBL to a remote database, I'm getting the error: "Lost connection to MySQL server during query". This error only occurs when connecting to a remote host. It occurs 100% of the time at exactly 15 seconds (which happens to be the wait_timeout value on the hosted server). I'm not having any issues with a local database. Is there a way to set a value to override the wait_timeout set on the server? I found this: http://dev.mysql.com/doc/refman/5.1/en/ ... nnect.html which leads me to belive there is a way, the question is can I configure MySqlDirect to use an interactive setting?
Additional info:
The query is against a single table with 5 records (so the timeout isn't due to a bad query). If I run the query using a different mysql client, it takes a good 20 or so seconds before the query runs, then it returns results. The query execution time is <200ms.
I can successfully execute the exact same query against the same hosted database using 2 other clients without error (so it's not a connectivity or network config problem).
Lost connection to MySQL server during query
Problem solved
In LLBL I updated the dbUtils class as follows:
Code: Select all
public static MySqlConnection CreateConnection(string connectionString)
{
MySqlConnection msc = new MySqlConnection(connectionString);
msc.ConnectionTimeout = 120;
return msc;
//return new MySqlConnection(connectionString);
}