Thank you for your help.
I've now inserted the setting fetchsize = -1.


>Hi Bruno,
>
>>Which is the correct approach to download data from 2 (or more) SQL Server tables synchronously, like if
>> acting with a VFP DB?
>
>you need to make sure, that you have fetched all records.
>The default setting of the "fetchsize" property is 100. In this case the connection is busy as long as not every record is fetched. Set the fetchsize of the CursorAdapters to -1.
>
>>
>>Besides, I wonder if the "connection is busy" problem might occur while performing a transaction with 2 or more tables involved.
>
>as long as you have just one query, it should not occur