locked
Where to ask question about timeout expired error in Visual Basic web app using .Net SQL provider RRS feed

  • Question

  • I'm trying my hand at my first web app. At the moment, the page is very basic, with only a List control and a Data Source containing an SQL SELECT query and referencing a Connection String for the SQL server to connect to and database to use. I've set a timeout value of 300 (5 minutes) in the Connection String.

    When I test the query in Visual Studio from the Configure Data Source dialogue, it runs for 30 seconds then throws up an error window with "There was an error executing the query. Please check the syntax of the command and if present, the types and values of the parameters and ensure they are correct. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding".

    If I run the same query (it has no parameters) in SQL Management Studio, it runs fine, taking about 40 seconds.

    Is this best posed in an SQL forum, a Visual Basic forum, a .Net forum, or other.

    Thursday, March 16, 2017 1:33 PM

Answers

  • They'll help you over here.

    https://forums.asp.net/36.aspx/1?Visual+Basic+NET

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Marked as answer by Tim Peters Thursday, March 16, 2017 5:27 PM
    Thursday, March 16, 2017 1:52 PM