Hello,

There is a knowledge base article on that. The best solution I have seen is to set the Number of records to fetch to All (-1) and the maximum number of records to fetch to All (-1) via the Query --> Advanced Options page or in code:

=DBSetProp('YourViewNamehere', 'View', 'FetchSize', -1)
=DBSetProp('YourViewNamehere', 'View', 'MaxRecords', -1)

Here is an excerpt from the knowledgebase article:

Knowledge base article Q191343

SYMPTOMS

Attempting to issue a CREATE SQL VIEW, USE or REQUERY() command with a 
REMOTE VIEW, results in the following error message: 

   Connection CONNECTION_NAME is busy.

This behavior occurs under the following conditions: 

•Two or more Remote Views are created using the same SHARED connection.
•The MAXRECORDS property of at least one of the VIEWS is set to a value greater than 0. 
•The FETCHSIZE property of at least one of the VIEWS is set to a value greater than 0. 
•The FETCHSIZE property value is less than or equal to the MAXRECORDS property value. 

Blah, blah, blah ....

Hope this helps,

Kevin