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