ODBC Connection

[wrkwinter]

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]
[\quote]

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 anybody please explain any reason for that.....

Thanks

 

[Tatertot45]

Since no one else has responded, i'll throw in my 2 pennies. Sounds like a Time out issue, to me. A couple of things i can think of. Go to the control panel and check out ODBC connection. You might have to click around and explore, but see if you can find a setting for timing out. I get that info on a pop-up window after i type in my password when i refresh data. Foe me, timeout is set at 120 minutes. the other thing you can do is try to connect Access or some other similar program and see if you get the same issues. Maybe go to another user and see if they get it. See if you can isolate the issue to CR or Access.

Other than that, i'm out of ideas...