|
|
|
| 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 ?
| |
| Sylvain Lafontaine 2005-04-06, 8:07 pm |
| Disconnected? Can you be more specific about your installation and the
error message?
S. L.
"Ben" <null@void.com> wrote in message
news:eNJV9xhOFHA.1884@TK2MSFTNGP15.phx.gbl...
> 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 ?
>
>
| |
|
| access 2k2 on sql2000sp3a ADP
disconnects frequently
sql db is 3 states away
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:O7LRTolOFHA.1732@TK2MSFTNGP14.phx.gbl...
> Disconnected? Can you be more specific about your installation and the
> error message?
>
> S. L.
>
> "Ben" <null@void.com> wrote in message
> news:eNJV9xhOFHA.1884@TK2MSFTNGP15.phx.gbl...
>
>
| |
|
| [DBNETLIB]Connection
Read recv() General network error
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:O7LRTolOFHA.1732@TK2MSFTNGP14.phx.gbl...
> Disconnected? Can you be more specific about your installation and the
> error message?
>
> S. L.
>
> "Ben" <null@void.com> wrote in message
> news:eNJV9xhOFHA.1884@TK2MSFTNGP15.phx.gbl...
>
>
| |
| J. Clay 2005-04-06, 8:07 pm |
| 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@void.com> wrote in message
news:OZWeVPrOFHA.3356@TK2MSFTNGP12.phx.gbl...
> [DBNETLIB]Connection
Read recv() General network error
>
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:O7LRTolOFHA.1732@TK2MSFTNGP14.phx.gbl...
keep[color=darkred]
unattended[color=dar
kred]
>
>
>
| |
| Sylvain Lafontaine 2005-04-06, 8:07 pm |
| 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@NoSpam.nospam> wrote in message
news:%23BxqNsrOFHA.3668@TK2MSFTNGP14.phx.gbl...
> 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@void.com> wrote in message
> news:OZWeVPrOFHA.3356@TK2MSFTNGP12.phx.gbl...
> keep
> unattended
>
>
>
| |
|
| 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@TK2MSFTNGP15.phx.gbl...
> 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@NoSpam.nospam> wrote in message
> news:%23BxqNsrOFHA.3668@TK2MSFTNGP14.phx.gbl...
network[color=darkre
d]
it[color=darkred]
the[color=darkred]
>
>
| |
| Sylvain Lafontaine 2005-04-12, 11:26 am |
| 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" <test@test.com> wrote in message
news:eSruHNwPFHA.1236@TK2MSFTNGP14.phx.gbl...
> 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@TK2MSFTNGP15.phx.gbl...
> with
> spyware
> network
> it
> the
>
>
| |
|
|
localhost->router->internet->hardware firewall (cisco pix)->db server
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:%23uA6Qh3PFHA.3596@TK2MSFTNGP15.phx.gbl...
> 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" <test@test.com> wrote in message
> news:eSruHNwPFHA.1236@TK2MSFTNGP14.phx.gbl...
the[color=darkred]
ADP,[color=darkred]
[color=darkred]
table[color=darkred]
very[color=darkred]
and[color=darkred]
projects[color=darkr
ed]
>
>
|
|
|
|