I have a Microsoft Access application which imports data from various databases (SQL Server 2000 & Oracle) and generates reports. SQL Server and Oracle databases are on different servers.

It works fine. But some times i get "ODBC Connection Failed" error in one machine and it works fine in others at the same time . i even cheked if the servers were down. I checked if the systems had similar DSN . Some times if i restart the server it might solve the problem.

Any help would be appreciated.