CF5 Loosing connection to MySQL server during query

[rdg]

I recently switched from using Access tables to using mySQL. Am
experiencing frequent errors of "lost connection to mySQL server."

Occurs more or less randomly, not on specific queries. Doing a page
reload is usually successful.

This is an example of a query that has timed out frequently - a simple
query against a table with less than 100 records.

ODBC Error Code = S1T00 (Timeout expired)<P> Lost
connection to MySQL server during query<P>
<P>SQL = "Select * from menulist"

I am using a dynamic query type with a connection string as follows:
"driver={MySQL ODBC 3.51
Driver};server=ServerIPaddress;port=3306;database= dbname;Uid=userID;Pwd=password;option=3;"

I am subscribed to a shared server environment, tech support so far
unable to determine why this is happening.

Any help much appreciated.

-Rick DelGreco
Vegetable Kingdom