MySql in web lost conection after 30s

[ntsinfo]

When I use the componet Unidac in a MySQL database hosted on the web, have a loss of connection error.

I know this may be adjusted by changing the variable from mysql to clientflag 1696

How do I do this in Delphi?

Sorry for my english


Below the specifications

CLIENT_LONG_PASSWORD = 1; // new more secure passwords
CLIENT_FOUND_ROWS = 2; // Found instead of affected rows
CLIENT_LONG_FLAG = 4; // Get all column flags
CLIENT_CONNECT_WITH_DB = 8; // One can specify db on connect
CLIENT_NO_SCHEMA = 16; // Don't allow database.table.column
CLIENT_COMPRESS = 32; // Can use compression protcol
CLIENT_ODBC = 64; // Odbc client
CLIENT_LOCAL_FILES = 128; // Can use LOAD DATA LOCAL
CLIENT_IGNORE_SPACE = 256; // Ignore spaces before '('
CLIENT_PROTOCOL_41 = 512; // Support the mysql_change_user()
CLIENT_INTERACTIVE = 1024; // This is an interactive client
CLIENT_SSL = 2048; // Switch to SSL after handshake
CLIENT_IGNORE_SIGPIPE = 4096; // IGNORE sigpipes
CLIENT_TRANSACTIONS = 8192; // Client knows about transactions

CLIENT_RESERVED = 16384; // Old flag for 4.1 protocol (4.1.9)
CLIENT_SECURE_CONNECTION = 32768;// New 4.1 authentication

CLIENT_MULTI_STATEMENTS = 65536; // Enable/disable multi-stmt support
CLIENT_MULTI_RESULTS = 131072; // Enable/disable multi-results
CLIENT_CAPABILITIES = (CLIENT_LONG_PASSWORD or CLIENT_LONG_FLAG or CLIENT_LOCAL_FILES or CLIENT_TRANSACTIONS or CLIENT_PROTOCOL_41 or CLIENT_SECURE_CONNECTION or CLIENT_MULTI_STATEMENTS or CLIENT_MULTI_RESULTS);

[AndreyZ]

Hello,

This problem is connected with MySQL server work and not with UniDAC. You can read more about this problem here:
http://dev.mysql.com/doc/refman/5.1/en/ ... ction.html
http://dev.mysql.com/doc/refman/5.1/en/ ... ad_timeout