Hi Pascal if you are using view disigner go to the advance options and check the share connection checkbox.
if you are creating the view with the CREATE SQL VIEW then put the keyword SHARED after the connection name.
>In my application I use a mix of sql passthrough and remote views (like everyone does, I suppose).
>
>The remote views each open a connection when the're USEd.
>On a local SQL server ; no problem, but over a slow (dialup) line I have a performance problem : one or 2 views are not a problem, but when I open several, I have a wait time of some seconds, due to the fact that each view opens it's own connection. Can I force them to all the same connection to win time ?
Alexandre Palma
Senior Application Architect