Hi Victor,
It could be a combination of settings. If multiple tables are being opened via the same connection and it's an asynchronous connection, you might run into this error. Why do you have share connections set? Is there a resource issue...the best performance and the least hassle will be to leave share connections OFF.
>
>I have a VFP 6 SP3 app running with a SQL 7 Backend. I m using shared connections but want I want to retrieve a small recordset -280 records- I get the -Connection is busy- error. I have set the rows to retrieve to 100. When I set it to 300 the problem is gone but I'd like to be able to download the data in the 100 records rate because I have a slow connection to the server. Any idea?
>
>
>TIA
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05