We need an application that runs on a Windows 2000 server as a service that will continuously pull data from a serial port and automatically store the data on another MS SQL database server. We would like some amenities that could be negotiated now or later such as email if the service or serial port stops receiving data or if errors occur such as can not connect to the SQL server and such and be able to data verification checking. At a minimum it must pull the data from a serial port and store those values in an SQL server with a Date and time stamp.
## Deliverables
The serial device is a Radio Decoder Model5051D from hydroLynx [login to view URL] Included for download is the Transmission formats. The Serial port will be receiving a Binary transmission so it must be converted to a readable format and able to store it in the database. Background: This application is for a Weather ALERT system. A series of gauges that measure Rainfall (Precipitation) , River flow, and other things are sent via Radio Telemetry to a Radio receiver. the Signal is then sent to a Decoder that is connected to the server. We need the ability to permanently store these values as they are received for use in other applications. The organization is currently using the DIAD [login to view URL] system however they are not related. The DAID system collects the data as it is received and stores it locally on an Access Database and then flushed clean every few days. ALERT data arrives in one of two binary formats... There is an old ASCII format and Binary Format. We need that application to convert the ALERT binary formats... The decoder would basically analyze the bits coming off the serial port and attempt to identify valid ALERT reports, thus filtering out noise and 'broken' reports, then correctly convert the binary data to a sensor ID and data value. Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Platform
Visual Basic 6 or .NET to be run on a Windows 2000 server AS a service.