So I have a situation where:
- I’m setting username and password in the asset to connect to Oracle DB.
- In my code, I’m fetching username and password through GetRobotCredential activity.
- Then converting the secure string password to string using below code:
new System.Net.NetworkCredential(string.Empty, password).Password
- After that using Database connect activity to connect to DB.
Now the problem is that this was working fine earlier. But few days ago the password got changed for my DB and when I’m trying to run my code again now, my DB connection is failing.
Upon logging the connection string, I found out that old password is getting retrieved every time instead of me setting the new password in the asset.
What should I do to solve this. I don’t want to hardcode my password in the connection string while connecting to Oracle DB.