Hi!
In VFP7 itis not possible to share connections with CONNSTRING. It will be possible only in VFP8.
>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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.