To implement an encrypted connection to an MS SQL database on Azure using Excel macros (in VBA language).
The expected work product is a class file containing the procedures and functions required to implement the functionality.
Additionally, documentation will be required containing:
- solution design
- functional specification
- system requirements
- test scenarios
- test results
- code documentation (can be in a form of comments)
establishing an encrypted connection to the MSSQL database on Azure executing a query to the database execute procedure without input parameters execute procedure with input parameters execute procedure without input parameters returning data execute the procedure with input parameters returning data passing the input parameters as an object of the Collection class return the result of the procedure as an object of the String class returning the result of the procedure as an object of the Recordset class
Add your offer or ask the client for more details
