I require a simple app that will allow a user to pick data fields from a selected data source. The app will begin by allowing the user to select their data source (which may range from at least an MS Access database [all versions], MS SQL server db, and possibly other databases too (ie. Oracle, DB2, UDB etc.)), including user entry of any security features (ie. Logins/passwords etc).
Once the data source has been selected and connected to, the app should display a branched tree showing all tables and queries held in that database. The user should then be able to browse through the data fields in each table/query branch, and select required data fields, to which access should then be available for the rest of the program. If possible, an option may be available for the user to setup their own query ‘on-the-fly’ allowing them to write an SQL statement to automatically pick the data they require, without having to manually select it all, however this is not a major element for concentration, but an aside.
Once the data fields have been selected, dynamic access to them is vital for the final app.
The code should be written in Visual C++, within a Windows environment (i.e. the user interface should be in Windows Programming).
**KEY REQUIREMENTS:
- Must be in Visual C++ with Windows GUI
- Must be able to select _ANY_ version of MS Access DB and MS SQL Server DB
- Possibly be able to select other types of databases
- Access to select data fields must be dynamic**
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
The code should be written in Visual C++, within a Windows environment (i.e. the user interface should be in Windows Programming).