Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connection with MYSQL ODBC

Status
Not open for further replies.

wrkwinter

Technical User
Jun 25, 2007
3
US
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.
"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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top