Using VFP 5.0 as a front end and SQL Server 6.5 as a back end we are having this Connection busy problem.
We use statements like CREATE SQL VIEW viewname REMOTE CONNECTION connectionname SHARE AS SELECT ... to create views based on remote tables.
Problem is we are getting the Connection connectionname is busy message. Using what Microsoft indicates for this case (in a context like):
lnHandle=CursorGetProp('ConnectHandle')
do while SQLGetProp(lnHandle,'ConnectBusy')
enddo
just doesn't work.
Then we decided to download all the records from the remote tables at once (not in lots of 100 for example). This fixed the problem on development machines (the ones that have VFP installed).
But on client machines (which don't have VFP isntalled) the problem is still there.
We would really appreciate a solution for this problem.
Thanks a lot.
Cheers