The views are all marked as shared.
It works fine if we use a connection stored in the database, only a single pipe is used.
As soon as we use a connection string via CONNSTRING, multiple pipes are used.
>Hi!
>There is an option for view - SHARED. Look in the menu for view's additional options.
>>Is there any way to limit remote views to share a single connection to a SQL Server back-end?
>>
>>Currently each view is opening it's own connection to the server. The views are being opened with a connection string.
>>
>>Possibly need some arcane commands in the connection string?
>>
>>All help appreciated.
- Craig
"If you're not prepared to be wrong, you will never come up with anything original."
- Sir Ken Robinson