Encrypt the user and password in string connection

[fkeuroglian]

Hi people

i have a question, i have an include that use a txt that contains the string connection, for example this is my string conection in a txt

OLEDB CONNECT TO [Provider=IBMDASQL.DataSource.1;Persist Security

Info=True;User ID=usertest;Data Source=SERVER;Protection Level=None;Xml Strip

Whitespace=True;Password=1234];

is there a way to encrypt the user and the password?

thank you a lot

Fernando

[tresesco]

This should be done at driver-end you use (OLEDB for you). Refer: Re: User and password encryption in odbc string

[ashfaq_haseeb · Accepted solution]

Hi,

In your edit script --> Setting tab --> make sure scramble user credentials is selected.

Have a look at the attached image.

Regards

ASHFAQ

[jonathandienst]

Hi

You can also put the connection string in a hidden script tab

HTH

Jonathan

[ashfaq_haseeb]

Hi,

Then handling multiple connection with multiple database will be more difficult.

Unless we move entire code to hidden script.

Regards

ASHFAQ

[jonathandienst]

Ashfaq

That's no problem. Create one or more SUB routines in the hidden tab (one per unique connection) and CALL the relevant subroutine to make the connection.

Jonathan

[ashfaq_haseeb]

Thanks

I learned something new.

Regards

ASHFAQ