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.
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.
Re: Set of records recordset.Open hangs in vb6
Quote:
Originally Posted by
Temur2
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?