Directly out of TechNet ... you might want to try this first.


This article was previously published under Q217082

SYMPTOMS

When attempting to open a Remote View using a shared connection to access SQL Server tables, the following error message may appear:

Connection "connection name" is busy

RESOLUTION
Set the FETCHSIZE property of remote views using shared connections to a value of -1.
OPEN DATABASE MYDATA
=DBSETPROP('MyView','View','FetchSize',-1)

-or-

OPEN DATABASE MYDATA
USE MyView IN 0
SELECT MyView
=CURSORSETPROP('FetchSize',-1)

Setting the FetchSize Property of the remote view to -1 causes Visual FoxPro to retrieve the complete result set (within the limits set by the MaxRecords setting).
MORE INFORMATION
The default FetchSize Property value for remote views is 100.

The error message indicates that the shared remote connection is in use by another executing statement. This behavior occurs when multiple remote views have been defined with the following characteristics:


Using a shared remote connection to the server.
Accessing the same base table(s).
The number of records being returned is greater than or equal to the FETCHSIZE property of the view.