Implementation of encrypted connection to MSSQL database in VBA

Employer
swojcik
swojcik
Description

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)

Published
on 2022-03-02
Required functions:
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

Offers sent (2)

Budget
Negotiable
Copyright
-
Expires in
30 days