Forum Discussion

sgarcia's avatar
sgarcia
Contributor
2 years ago

Is it possible to use a password variable in a database connection string?

Here is the connection string that I've been able to use by hardcoding the user and password. I want to use the password variable in place of the 'password' for security reasons. The problem is it's ...
  • rraghvani's avatar
    rraghvani
    2 years ago

    You can do this,

     

    conn = "Driver={PostgreSQL UNICODE};Server=servername;Port=5432;Database=testenvironment;Uid=username;Pwd=" + Project.Variables.MyPassword.DecryptedValue

     

rraghvani's avatar
rraghvani
Champion Level 3

You can do this,

 

conn = "Driver={PostgreSQL UNICODE};Server=servername;Port=5432;Database=testenvironment;Uid=username;Pwd=" + Project.Variables.MyPassword.DecryptedValue

 

sgarcia's avatar
sgarcia
Contributor
2 years ago

Thank you! That did the job.