Create a Windows Service that executes a routine daily. The routine will run a query against a MySQL database and write a text file (comma separated values) to disk. The source query that is compatible with Microsoft Access will be provided as well as a sqldump of the database. This query uses some functions/syntax [Format() and IsNumeric()] that is not compatible with MySQL. The query will need to be modified so that it executes with MySQL. A sample of the query output and the resultant file output is also provided along with a VBScript file that can be used as a guide for the required format of the output file.
**Source Database:**
MySQL 5.0.41
**Connection String:**
MySQL ODBC 3.51 Driver
## Deliverables
See included ZIP file that contains additional detailed information regarding project.