CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2023
    Posts
    1

    Set of records recordset.Open hangs in vb6

    I have a problem. There is an app in vb6 working with SQL Server 2008.
    In db there is the table EquRSh with 8000 rows. I get one record with the help recordset. The string SQL has as follow
    StrSQL="SELECT F1, F2, F3 FROM EquRSh WHERE (F4=" & N4 & " And F5=" & N5 & ")"
    where N4, N5 are integer variables.
    The recordset rs.Open works for a longtime and hangs and gives the message:
    Time of waiting exceeded.
    In the case of string SQL
    StrSQL2="SELECT F1, F2, F3 FROM EquRSh WHERE (F4=" & N4 & ")"
    recordset normally and fast gives a result.
    In the case of 1-string SQL in principe we get one record that not many.
    In SS Management Studio given query gives fast a result.
    What to do? Help, please.

  2. #2
    2kaud's Avatar
    2kaud is offline Super Moderator Power Poster
    Join Date
    Dec 2012
    Location
    England
    Posts
    7,822

    Re: Set of records recordset.Open hangs in vb6

    May I suggest you post this in this site's sister site:
    https://www.vbforums.com/forumdispla...-6-and-Earlier

    You will probably receive a better response.
    All advice is offered in good faith only. All my code is tested (unless stated explicitly otherwise) with the latest version of Microsoft Visual Studio (using the supported features of the latest standard) and is offered as examples only - not as production quality. I cannot offer advice regarding any other c/c++ compiler/IDE or incompatibilities with VS. You are ultimately responsible for the effects of your programs and the integrity of the machines they run on. Anything I post, code snippets, advice, etc is licensed as Public Domain https://creativecommons.org/publicdomain/zero/1.0/ and can be used without reference or acknowledgement. Also note that I only provide advice and guidance via the forums - and not via private messages!

    C++23 Compiler: Microsoft VS2022 (17.6.5)

  3. #3
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,395

    Re: Set of records recordset.Open hangs in vb6

    Quote Originally Posted by Temur2 View Post
    I have a problem. There is an app in vb6 working with SQL Server 2008.
    In db there is the table EquRSh with 8000 rows. I get one record with the help recordset. The string SQL has as follow
    Code:
    StrSQL="SELECT F1, F2, F3 FROM EquRSh WHERE (F4=" & N4 & " And F5=" & N5 & ")"
    where N4, N5 are integer variables.
    ...
    In SS Management Studio given query gives fast a result.
    What to do? Help, please.
    Did you try to output the SQL string (StrSQL) after you have formatted it and test exact this string in SSMS?
    Victor Nijegorodov

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured