Forum Discussion

Sjef's avatar
Sjef
Occasional Contributor
2 years ago

Use Variables in the sql connectionstring

Hi there, I'm using 2 environments and 2 databases: 1 to create the testcases and 1 to execute them I want to check the results with DBTables Custom queries (SSMS) and I have i.e. next connect...
rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
2 years ago
Copy Link

It's not possible within that dialog. However you can use ADO Object and create your own connection string using variables e.g.

function ADOExample()
{
    var AConnection = ADO.CreateConnection();
    var dbServer = "Server1";
    var dbName = "ALPHA";
    AConnection.ConnectionString = "Provider=MSOLEDBSQL19.1; Integrated Security=SSPI; Persist Security Info=False; Initial Catalog=" + dbName + "; Data Source=" + dbServer + "; Use Encryption for Data=False;";
    AConnection.Open();
   
    // Do something
   
    AConnection.Close();
}

 

Hanila's avatar
Hanila
Occasional Contributor
26 days ago
Copy Link

Hi RRaghavani,

How can i store my Db password in project variable and call that in the connection string?

As password is encrypted , I am not able to call it directly as Project.Variables.sqlReadOnlyPWD. Could you please help me if you have a solution .

 

Currently I have hardcoded the password in the string and I understand its not the secure way of execution