this is my evniroment :
Delphi 2009
DbExpress Driver for Mysql 4.40
I'm connecting to db with TSqlConnection, and SimpleDataset.
In database i had a blob file of about 13 Mb.
I create connection at runtime :
Code: Select all
ConnectionName := 'Devart MySQL Direct';
DriverName := 'DevartMySQLDirect';
LibraryName := 'dbexpmda40.dll';
VendorLib := 'not used';
GetDriverFunc := 'getSQLDriverMySQLDirect';
LoginPrompt := False;
l_Conn.Params.Add('HostName='+ l_Host);
l_Conn.Params.Add('DataBase=autoupdate');
l_Conn.Params.Add('User_Name=' + l_User);
l_Conn.Params.Add('Password=' + l_Password);
l_Conn.Params.Add('CommandTimeOut=3000');
l_Conn.Params.Add('Fetchall=False');
All work fine in local, because query is exec in about 4 seconds, but when i'm in remote i had a Mysql Has Gone Away exactly 60 seconds after the execution of query.
I had try to read elsewhere, commandtimeout, connectiontimeout etc but i can't solve this issue.
Can you help me ?
Thank's
Luca G.
Archimedia Solutions srl