Looping through Recordset hangs?
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
I have created a VB application which sole purpose is to create a simple text document. The application queries a SQL server 2000 database and returns a recordset containing 101 fields and typically less then 50 rows of data. I have run into a problem where randomly the application will hang while looping through the data. The problem has no correlation with regards to the number of records being returned. At this point my only thought is that there is a limitation with the ADO 2.7 component I am using. What I can’t explain is why this error does not occur every time. If you have had or heard of a problem similar to this I would greatly appreciate any assistance in resolving it. Thanks Jason W.