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.
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.