I've got software that is used by 20 or so people both through a local network and through the internet. The software (.net/c#) polls a sql database every 10 seconds or so to show plant data. This works as it should unless the user has a slow internet connection, such as 3g wireless tether. I have tried changing the connection timeout, but I always get this error after the timeout period.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Any help is greatly appreciated.
thanks
jim
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Any help is greatly appreciated.
thanks
jim