We recently upgraded one of our SQL Servers from 7 to 2000, and began experiencing seemingly random failures of the ODBC connections that worked previously without a hitch. When the failure occurs, the only recourse is to delete the existing DSN and recreate it. Then it seems to work for one or more reboots and then fails again. However some workstations have behaved correctly for 2 weeks. The workstations are all running Windows 2000 Pro with SP1 and Access 2k with SR1.

We've tried doing MDAC upgrades to 2.6 SP1 or 2.7 with limited success. Has anybody else out there seen similar problems. Thanks in advance.