ChanKokKiet
Wed Feb 16 02:17:02 CST 2005
HI,
We don't limit # of connections.
Again, it is ok for other forms.
"Cyrus Welch" wrote:
> Chan Kok Kiet wrote:
> > Hi,
> > We are using ViewDBC. Each user has own copy of viewdbc.
> >
> > "Cyrus Welch" wrote:
> >
> >
> >>Chan Kok Kiet wrote:
> >>
> >>>Hi,
> >>>Thank you for reply.
> >>>No, we are using SQL enterprise. Also, there are only TWO users.
> >>>
> >>>"Wolfgang Schmale" wrote:
> >>>
> >>>
> >>>
> >>>>Hi,
> >>>>
> >>>>If you're using MSDE I would think that are more than 5 connection open. The
> >>>>MSDE allows only 5 connection opened at the same time.
> >>>>
> >>>>--
> >>>>
> >>>>
> >>>>------------------------------
> >>>>
> >>>>Mit freundlichen Gü�en aus der Zigarrenstadt
> >>>>
> >>>>Wolfgang Schmale
> >>>>
> >>>>------------------------------------------------
> >>>>"Chan Kok Kiet" <ChanKokKiet@discussions.microsoft.com> schrieb im
> >>>>Newsbeitrag news:68783CCE-217F-434B-9B6B-163EDD566536@microsoft.com...
> >>>>
> >>>>
> >>>>>Hi,
> >>>>>I am using remote view to access sql server database, I have a problem
> >>>>>that,
> >>>>>my 2nd instance of app be blocked.
> >>>>>
> >>>>>After some investigation, we found that SQL server block one of my
> >>>>>instance
> >>>>>since it is blocked by another. I am using auto transaction, optimistic
> >>>>>table
> >>>>>buffering, share connection.
> >>>>>
> >>>>>I would able to solve it by adding (NOLOCK) in my sql statement. No
> >>>>>blocking
> >>>>>shown in enterprise manager. But why it cause blocking?
> >>>>>
> >>>>>Thank you
> >>>>
> >>>>
> >>>>
> >>Do you have exclusive set off? If you have exclusive set on, it may be
> >>that what is happening is the second instance can't open the DBC to get
> >>to the remote views.
> Are you sure you have SQL Server setup to allow enough connections to
> let both users connect? Just what is the error your getting when the
> second user tries to connect?
>
> --
> Cy Welch
> Senior Programmer
> MetSYS Inc
>
http://www.metsysinc.com
>