Forum Discussion

Hanila's avatar
Hanila
Occasional Contributor
6 months ago
Solved

How to pass in a parameter to DB connection string

 var Qry = ADO.CreateADOCommand()     Qry.ConnectionString = "Provider=PROVIDERDB;Data Source=SOURCEADDRESS;Initial Catalog=MYDBNAME;User ID=USERID;Password="+ProjectSuite.Variables.sqlReadOnlyPWDIN...
  • rraghvani's avatar
    rraghvani
    6 months ago

    A while back, I provided a possible solution, see  Encrypt/Decrypt Base64 string in TestComplete | SmartBear Community - I didn't have dotNet extension installed or the appropriate license, so I was unable to provide the full code. However, the snippet of code was able to help. You could implement something similar.

    If the automation scripts is being used by a team, would it not be best to have a dedicated user account to access the database?

Hanila's avatar
Hanila
Occasional Contributor
6 months ago

Thank you RRaghavani and Hassan.

I will surely keep this in my learning record. In our structure, the user with access to the tool and the pipeline has no 365 account, which means I cant use the above structure. 

Customer care team gave me the solution to Decrypt at the end of calling parameter.    Parameter.DecryptValue. This way I can store the details in password format and retrieve it as required for the connection string. 

Do you guys have any suggestions on this approach ? 

 

  • rraghvani's avatar
    rraghvani
    Icon for Champion Level 3 rankChampion Level 3
    6 months ago

    A while back, I provided a possible solution, see  Encrypt/Decrypt Base64 string in TestComplete | SmartBear Community - I didn't have dotNet extension installed or the appropriate license, so I was unable to provide the full code. However, the snippet of code was able to help. You could implement something similar.

    If the automation scripts is being used by a team, would it not be best to have a dedicated user account to access the database?