To be honest, I don't know what VFP will do under that scenario.
I will something like that in a couple of months. I hope I will remember to come back here to post my findings :)
>But this doesn't apply if you are doing a VFP .DLL running inside MTS, right? In that case you want to make the .DLL think it is monopolizing the connection and let MTS take care of the ODBC work for you, right?
>
>
>
>>When connecting to SQL Server you will see that establishing the connection is one of those things that takes the most. Sharing the connection enables your application to connect just once and thus improving performance while opening other views.
Hector Correa