ODBC Connection Hangs after 15 minutes of non-use

I have several workstations that login to a WIN_2000 Server and Connect just
fine to a SQL-2000 Server (different machines) over a dedicated VPN....
They have a x.x.2.1 addressing scheme and we have x.x.1.1 addressing scheme.
Everything works beautifully for a while.
My application runs a MailMerge with Word and Access 9.0 with tables linked
to the SQL Server 2000 server.... The code uses a pre set up ODBC
connection (SQL Server) that connects just fine right after start up...
Code works and ODBC connection works.... However, after 15-45 minutes the
ODBC connection stops working... This can be verified by testing the ODBC
applet which hangs
I have 50 local users who have no issues with the setup - only these few
remote users.
I have set the server autoconfigure to never disconnect. (I can still
browse the servers)..
Any clues as to why the ODBC connection would become disabled after a short
period of time - requiring a reboot to work again?To me this sounds like an issue with the VPN not ODBC and SQL Server.
Mike O.
"Bob" <rrowe68@.hotmail.com> wrote in message
news:%23jMJEVX1DHA.536@.tk2msftngp13.phx.gbl...

quote:

---

> I have several workstations that login to a WIN_2000 Server and Connect

---

just

quote:

---

> fine to a SQL-2000 Server (different machines) over a dedicated VPN....
> They have a x.x.2.1 addressing scheme and we have x.x.1.1 addressing

---

scheme.

quote:

---

> Everything works beautifully for a while.
> My application runs a MailMerge with Word and Access 9.0 with tables

---

linked

quote:

---

> to the SQL Server 2000 server.... The code uses a pre set up ODBC
> connection (SQL Server) that connects just fine right after start up...
> Code works and ODBC connection works.... However, after 15-45 minutes

---

the

quote:

---

> ODBC connection stops working... This can be verified by testing the ODBC
> applet which hangs
> I have 50 local users who have no issues with the setup - only these few
> remote users.
> I have set the server autoconfigure to never disconnect. (I can still
> browse the servers)..
> Any clues as to why the ODBC connection would become disabled after a

---

short

quote:

---

> period of time - requiring a reboot to work again?
>
>

---