I need a piece of software that once every a predetermined period of time (ex: every 1 minute) will connect to a MS SQL 2008 database, execute a certain query and then disconnect.
In an event of a connection problem the software should retry the connection (for X times) and then show a message to the user.
The software will keep retrying the connection until success. When that happens another message should be shown saying that connection was recovered.
Software MUST be written in Visual Basic 6 (VB6).