>I've been reading up on the benefits of a shared connection and want to test it but I can't seem to get it to work. I am running VFP6/sp3 using remote views to MS SQL 2000. I am viewing and tracing using the ms sql performance monitor.
>
>It shows that FoxPro opens up a user connection for every RV that any forms load.
>
>I selected the tools/options/remote data tab and checked share connection. I compiled both ways and still I get a connection per view. I tried setting the connection property but it's read only.
>
>I thought I might create my connection on the fly when the user logs in but the CREATE CONN doesn't have a SHARED clause.
>
>Any ideas?
>
>Thanks,
>
>Jose
You need to set the ShareConnection individually on the views. You may need to write a program to change this property in all your views.
dbsetprop( 'YourView', 'ShareConnection', .t. )
Hector Correa