DataSet Designer loses connection to MySQL

Posted on 2009-02-18
Medium Priority
Last Modified: 2013-11-26
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?
Question by:OneMHz
LVL 15

Accepted Solution

aibusinesssolutions earned 1500 total points
ID: 23676834
You could try increasing the timeout in the my.cnf file.

wait_timeout = 1800
connect_timeout = 10

Author Closing Comment

ID: 31548354
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.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question