When the field in SQL is a text field, it gives a data type mismatch error. But when it is a varchar type it's fine. I've tried cstr() and it still doesn't work. Also, I'm not allow to change the field in the sql table to varchar because it's not my database.
This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.