Hi,
I am having problem with conecting Crystal Report XI to the MYSQL Server. I am using Mysql Connector/ODBC 3.51. I configured ODBC connection . Once i connect to MYSQL server thru Crystal Rpeort Everything works fine but after 5-10 minutes if i refresh the report I get following error.
and if i log off and relog on to database everything works fine like for another 5-10 minutes and after that same ERROR
But if i use MYSQL Query Browser to connect to the database. I don't have any problem like that.
Can please explain any reason for that.....
Thanks
I am having problem with conecting Crystal Report XI to the MYSQL Server. I am using Mysql Connector/ODBC 3.51. I configured ODBC connection . Once i connect to MYSQL server thru Crystal Rpeort Everything works fine but after 5-10 minutes if i refresh the report I get following error.
"Failed to retrieve data from the database"
Details
HY000:[MySQL][ODBC 3.51 driver][mysqld-4.1.22-standard-log][MySQl server has gone away[Database vendor code :2006]
and if i log off and relog on to database everything works fine like for another 5-10 minutes and after that same ERROR
But if i use MYSQL Query Browser to connect to the database. I don't have any problem like that.
Can please explain any reason for that.....
Thanks