Debugging ODBC application

[ouuch@xxxxxxxxxxx]

Hello,

well, I'm still debugging this ODBC application. It is written/maintained in 
VisualBasic by
another company and running on a Windows2000 server. It uses the Client Access 
Express
ODBC driver.

We have heavy performance problems with this VB-app. With STRDBG and some deep
digging I found that the app is doing a

          select * from vrosif where sistat='40' or sistat='41' or sistat='43'

which returns about 1000 to 5000 records. In the QZDASOINIT joblog I see several
thousand log entries like:

              1 record retrieved from vrosif.

Obviously, the VB-app does a fetch for every single record of the query. This 
easily takes
30 seconds.

Doing the query manually through the tool SQLTHING I see  a few messages like

             500 records retrieved from vrosif
             500 records retrieved from vrosif
             297 records retrieved from vrosif

This easily executes in 1-2 seconds!

I need to tell the VB-programmer how to achieve this (I have no knowledge about 
VB and
ODBC programming).

Are there settings in the ODBC-driver for this record blocking or has this to 
be programmed
in VB? Some sample lines of code would be nice..

Thanks in advance,

Oliver Wenzel