Link to home
Start Free TrialLog in
Avatar of OneMHz
OneMHz

asked on

DataSet Designer loses connection to MySQL

I'm working in Visual Studio 2008 on an app that uses strongly typed DataSets with MySQL as the backend.  It seems like the dataset designer is losing the connection to the database so when I try to update the dataset, it can't read the metadata (tables/fields/datatypes/etc) and I either have to manually fix the XSD or close and restart Visual Studio to get it to reconnect.  I think it has something to do with the idle connection timeout of the database (my DB client frequently complains that it lost the connection too, but at least it reconnects and continues on its way).  I don't know how to change the idle connection timeout or to force VS to reconnect without restarting altogether.  Can anyone offer any suggestions?
ASKER CERTIFIED SOLUTION
Avatar of aibusinesssolutions
aibusinesssolutions
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of OneMHz
OneMHz

ASKER

Thanks!  That seems to have helped keep it from disconnecting.  For future reference, if anyone can tack on a method to reconnect without restarting my whole IDE, I'd love to know that too.