none
Creating a new data source in Visual Studio timing out RRS feed

  • Question

  • When I try to add a new data source in Visual Studio 2010 SP1 or 2012, it times out. All I'm selecting is one tiny table with no relationships. How can this be? I've increased the connection timeout to 1000 seconds and it still times out! But the exact same query in MySQL Workbench runs in 2 seconds.

    The error I get is:

    "Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding"

    What I'm doing is:

    1. I go to the Data Sources window in Visual Studio
    2. I click on the "Add New Data Source" button
    3. I select "Database" and click "Next"
    4. I select "Dataset" and I click "Next"
    5. I select my connection, who's connection string is:
    "server=40.180.40.123;User Id=******;password=******;database=test;Connect Timeout=1000"
        and click "Next"
    6. I select one table and click "Finish"

    It then takes a couple of minutes and times out.

    It is connecting to a MySQL Server 5.5 database using the MySQL .NET Connector 6.6.5. I am running Windows 7 64 bit SP1 with all updates for both windows and Visual Studio 2010 and 2012.
    Any ideas?


    Fabricio Rodriguez Pretoria, South Africa

    • Moved by Amanda Zhu Thursday, April 11, 2013 1:48 AM
    Tuesday, April 9, 2013 2:53 PM

Answers

All replies

  • Hello,

    Thank you for your post.

    What type of app/project are you working with? WPF app? Winform app?

    Hope you provide us more information about your scenario.

    Best regards,


    Amanda Zhu [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, April 10, 2013 9:47 AM
  • Hi Amanda, and thanks for the reply. It is a WinForm application, targeting the .Net 2.0 framework.

    I do have one very large dataset in the project which, as it had grown, had started giving me timeout errors when tryin go edit and then save it. That is why I am trying to create a new dataset now. Do you think somehow that big dataset is interfering in the creation of a new dataset in the same project?


    Fabricio Rodriguez Pretoria, South Africa

    Wednesday, April 10, 2013 10:10 AM
  • Hello,

    I have moved this thread to ADO.NET Managed Providers forum for better response.

    Best regards,


    Amanda Zhu [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Fabs1977 Monday, October 30, 2017 7:19 AM
    Thursday, April 11, 2013 1:49 AM