Our company has about 25 stores. We have a server in our home office that reaches out and grabs data from the Micros databases at the stores using ODBC. Everything works fine except for our newest store, where we intermittently get this error when our office server tries to connect:
Could not connect to the database. Database server not found SQLCODE=-100, ODBC 3 State="08001" You are not connected to a database.
The ODBC log shows this:
09:20:31 TCP/IP link, function connect(), error code 10060 09:20:31 Failed to connect over TCPIP
We have gone through the ODBC connections and compared them between the new store and the old stores and everything matches exactly. The store server does not have a software firewall. What could cause this error?
Could it be a hardware firewall setting?
Could it be something going into sleep mode?
When I open the ODBC interface on the office server and click "Test Connection", the first time it frequently times out, but if I click "Test Connection" immediately after it will succeed. Then if I wait a few minutes it will fail again the first time but succeed immediately after.
We have tried letting the office server ping the store server for hours and it runs with no packet loss or maybe 1 or 2 packets, but it does not appear to be a connectivity issue.
The Micros servers have Adaptive Server Anywhere 9.0. The office server has SQL Anywhere 10.
Any suggestions for how to fix this would be greatly appreciated!