Aubrey,
This certainly should work. Are you actually opening the views at the same time rather than opening one, closing it, then opening another? If you do that VFP will drop one connection and open another.
Did you check the ShareConnect for all of the views? If one is set to share and the other isn't, the connection won't be shared.
You're right that you should only get one connection as long as all the views are using the same connection in your dbc, you open all the views at once, and they're all set to share connections.
>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