DataSet Designer loses connection to MySQL

Posted on 2009-02-18
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

    You could try increasing the timeout in the my.cnf file.

    wait_timeout = 1800
    connect_timeout = 10
    LVL 3

    Author Closing Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now