Re: disconnected
- From: "Ben" <test@xxxxxxxx>
- Date: Mon, 11 Apr 2005 22:01:03 -0400
Hi,
Will using linked tables help my cause?
Enterprise manager doesn't give me any errors over periods of time, but I'm
not sure if it automatically reconnects from a dropped connection.
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:uFi9bosOFHA.1884@xxxxxxxxxxxxxxxxxxxxxxx
> I will add to that that recently I have seen an unstable VPN connection
with
> a machine that has been infected by spywares. At least one of these
spyware
> was spoofing is TCP-IP address; which resulted by the server dropping the
> VPN connection after a few minutes.
>
> One way to verify that would be to see if Enterprise Manager is also
> dropping its connection after a few minutes. If it does, than clearly ADP
> is not responsible here.
>
> S. L.
>
> "J. Clay" <JClay@xxxxxxxxxxxxx> wrote in message
> news:%23BxqNsrOFHA.3668@xxxxxxxxxxxxxxxxxxxxxxx
> > Sounds like you may have a couple of issues.
> >
> > 1) Your WAN is not stable. Somewhere along the way you are having
network
> > issues.
> > 2) You may need to reveiw your application's design. Even with an ADP,
it
> > is very important to understand the how things work in a remoted
> > environment. You need to make sure that ANY data that is requested from
> > the
> > server includes a very narrow WHERE statement in order to limit the data
> > transfer to a bare minimum. You should NEVER try and open a full table
> > accross a WAN. The ideal is that you use stored procedures with
> > parameters
> > that limit form data to a single record. I have found this works very
> > well.
> > The trick here is that the built in navigation doesn't work.
> >
> > HTH,
> > Jim
> >
> > "Ben" <null@xxxxxxxx> wrote in message
> > news:OZWeVPrOFHA.3356@xxxxxxxxxxxxxxxxxxxxxxx
> >> [DBNETLIB]ConnectionRead recv() General network error
> >>
> >>
> >>
> >> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> >> wrote in message news:O7LRTolOFHA.1732@xxxxxxxxxxxxxxxxxxxxxxx
> >> > Disconnected? Can you be more specific about your installation and
the
> >> > error message?
> >> >
> >> > S. L.
> >> >
> >> > "Ben" <null@xxxxxxxx> wrote in message
> >> > news:eNJV9xhOFHA.1884@xxxxxxxxxxxxxxxxxxxxxxx
> >> > > Users keep complaining about their DB connection from ADP projects
> > keep
> >> > > disconnecting.
> >> > >
> >> > > Even when I develop i get disconnected, and I don't leave it
> > unattended
> >> > > for
> >> > > over 3 minutes
> >> > >
> >> > > What's going on ?
> >> > > can you make it automatically reconnect or something ?
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >>
> >
> >
> >
>
>
.
- Follow-Ups:
- Re: disconnected
- From: Sylvain Lafontaine
- Re: disconnected
- References:
- disconnected
- From: Ben
- Re: disconnected
- From: Sylvain Lafontaine
- Re: disconnected
- From: Ben
- Re: disconnected
- From: J. Clay
- Re: disconnected
- From: Sylvain Lafontaine
- disconnected
- Prev by Date: Re: ADP/SQL Server 2000 Security Problem
- Next by Date: Re: ADP/SQL Server 2000 Security Problem
- Previous by thread: Re: disconnected
- Next by thread: Re: disconnected
- Index(es):
Relevant Pages
|
Loading
