disconnected

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

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 ?
 
Disconnected? Can you be more specific about your installation and the
error message?

S. L.
 
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 said:
[DBNETLIB]ConnectionRead recv() General network error



Sylvain Lafontaine said:
Disconnected? Can you be more specific about your installation and the
error message?

S. L.
Click to expand...
Click to expand...
 
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 said:
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 said:
[DBNETLIB]ConnectionRead recv() General network error



Sylvain Lafontaine said:
Disconnected? Can you be more specific about your installation and the
error message?

S. L.

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 ?
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
[DBNETLIB]ConnectionRead recv() General network error



"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message Disconnected? Can you be more specific about your installation and the
error message?

S. L.

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 ?
Click to expand...
Click to expand...
Click to expand...
 
Of course you may try with linked tables. Even if if doesn't help your
case, it can give you precious information about the cause of the error by
chance.

What kind of connection/configuration are you using?

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC


Ben said:
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 said:
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 said:
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

[DBNETLIB]ConnectionRead recv() General network error



"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam
please)>
wrote in message Disconnected? Can you be more specific about your installation and the
error message?

S. L.

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 ?
Click to expand...
Click to expand...
Click to expand...
 
localhost->router->internet->hardware firewall (cisco pix)->db server




Sylvain Lafontaine said:
Of course you may try with linked tables. Even if if doesn't help your
case, it can give you precious information about the cause of the error by
chance.

What kind of connection/configuration are you using?

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC


Ben said:
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 said:
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.

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
Click to expand...
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

[DBNETLIB]ConnectionRead recv() General network error



"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam
please)>
wrote in message Disconnected? Can you be more specific about your installation
Click to expand...
and
the
error message?

S. L.

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 ?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top