>Fabio:
>
>I use the default Asynchronous = .F. in SqlSetProp(), should I try changing that?
>
Well, don't change it.
On VFP8, VFPT it has resolved this issue one.
Use this:
DBSETPROP('RVName','view', 'AllowSimultaneousFetch',.T.)
With this, VFP declare a STATIC SERVER SIDE CURSOR,
and fetch it leaving drive ODBC in stateless mode.
Then you can shared the connection with others RV.
Read Thread #
960314.
>Also, this is interesting about =reccount(); how does that prevent the busy connection?
This force VFP to fetch all the RV records, and then this free the connection.
Fabio