I have a MS SQL database that holds a Date/Time and a Value for 15 or so locations. For example a current temperature. What I need to be able to do is be able to text from a cell phone to a number and it automatically return a text back of the last record in the database, or maybe the last 5 records. This is just one possible wy I am trying to find a solution for, but the problem is I have a few people that need to get this data from a non-Smart phone that can send text messages.
It was suggested that we cold do something with Google Voice to where a default voice-mail greeting was automatically updated (text to Voice) on the number assigned to that location. This would be even better, but finding any API for this has not been successful. I am open to any suggestions. This is for a non-profit, so budgeting is tight.
Must work on a Windows 2003 and 2008R2 server (currently using 2003 but will be upgrading soon)
Must be easy to use and easy to configure. We are using a MS SQL server 2000 and soon to be moving to 2008