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