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?
LVL 3
OneMHzAsked:
Who is Participating?
 
aibusinesssolutionsConnect With a Mentor Commented:
You could try increasing the timeout in the my.cnf file.

[mysqld]
wait_timeout = 1800
connect_timeout = 10
0
 
OneMHzAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.