Forum Discussion

Hanila's avatar
Hanila
Occasional Contributor
3 months ago

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...
Hassan_Ballan's avatar
Hassan_Ballan
Icon for Champion Level 1 rankChampion Level 1
3 months ago

As rraghvani pointed out and due to security constraints, prompting user for credentials is not a good solution for CI/CD. Depending on your dbms technology you will need to use a different authentication method other than user credentials. Ask your developers how do they connect, I am sure they are not storing credentials in the project.