I have created a database consisting of remote views to a SQL SERVER 7 database. I also created a connection in the database for the remote views to share.

When I open several views at one time I noticed I get a separate connect handle for each view in VFP. Also, I see a connection for each view using SQL Enterprise Manager.

I tested the 'shareconnect' property for each view using dbgetprop() which returned a True value.

I thought the share connect functionality was to limit the connections to SQL server. Is my understanding wrong or is there something more I need to do in order share a single connection using remote views.

Thanks,
Aubrey Cote