Encrypt Connection String To SQL Server From VBA Code
€8-30 EUR
Lukket
Slået op over 4 år siden
€8-30 EUR
Betales ved levering
I have an excel connected to Azure SQL Server.
I have written a code in VBA to query the database. In the VBA code I have hard-coded the connection string including the password to connect the file to the database.
I want to increase the safety of the file by encrypting the password and if it is possible the whole connection string.
I need some able to to that! The budget for this gig is 10 euro.
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year.
Willing to take up your project.
Thank you,
Regards.
Hello
it should like piece of cake, I would offer to just encrypt by some kind of symmetric algorithm, however
it's possible to trace and get connection string...
Hello, I've looked into your description and understood clearly. I am highly skilled in Excel VBA so I assure you I can do it perfectly. Please contact me so that I can start now. Thanks.
Siva
VBA is not so good for encryption because it's an interpretation language. To encrypt with security, we would need a binary file. Such as a DLL
There're some tricks we can do to encrypt. However anyone that sees the code behind would be able to hack it