ODBC Connection Hangs after 15 minutes on non-use

[Bob]

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?

[Russ Gray [MS]]

Hi Bob

FWIW, I've only seen something like this Once before. That turned ou to be
a router that was droppng the connection after an hour of Idle. I'd look at
the hardware that the users go thru that are experiencing the problem.

Thanks,

Russ Gray
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.