Rick,

Your problem is the FetchSize on the view. If you set it to -1 (fetch all at once) the problem should go away. What happens is that when a view returns more than 100 records, VFP continues execution after the first 100 are returned and fetches the rest in the background. The problem is that if it tries to open another view that uses the same connection you'll get the busy error. If you want to have the data fetched in the background you should make sure that views aren't sharing connections.

>Hello All (especially Josh)
>
>I sometimes see "connectionname is busy"
>
>What should the settings be for the following using Visual FoxPro 6 and SQL Server 7 (the number in parens is what I currently have)
>
>Remote Connection
> Asynch execution (not checked)
> Display warnings (not checked)
> Batch processing (checked)
> Automatic trans (checked)
> Timeout interval for connection (120)
> Timeout interval for idle (0)
> Timeout interval for query (0)
> Timeout interval for waittime (100)
>
>Views
> Fetchsize (100)
> Maxrecords (-1)
> Fetchasneeded (.F.)
> Fetchsize (100)
> Batchupdatecount (10)
>
> Thanks,
> Rick