Hard Code User Name and Password & Mail server

sdevashis · Post by **sdevashis** » Wed Dec 17, 2003 12:25 am

Hi,
While promoting the jobs to production enviroment I realised that I have to change the user name and password in all the places ...... Same with the mail component.

Is there anyway I can store them at a single place and use that at moltiple places???

WoMaWil · Post by **WoMaWil** » Wed Dec 17, 2003 1:23 am

use parameters

sdevashis · Post by **sdevashis** » Wed Dec 17, 2003 1:25 am

could you tell me the details

siddharthkaushik · Post by **siddharthkaushik** » Wed Dec 17, 2003 2:00 am

Hello Devashish,

Can you please also tell us which all stages are you using? If you are using the ODBC stage, then you cannot parameterize it; you will just have to change the username and passwords for all the stages and recompile the jobs.

In case of routines, you can write the username and password in a file and can read it from there.

Thanks,
Siddharth

sdevashis · Post by **sdevashis** » Wed Dec 17, 2003 2:01 am

I am using ODBC

peterbaun · Post by **peterbaun** » Wed Dec 17, 2003 2:34 am

Hi -

Maybe I haven't understood what you ask -
but there are no problems in using parameters in the ODBC stage for
"Data Source Name", "User Name" and "Password" (and for tablename and in the where-clause).

It is completely standard eg. -
create the parameter eg. UserName
enter #UserName# as the name in "User Name"

You can do the same thing with password - except you cannot see what you enter since the keystrokes are converted to "*" - but it will work. Pretty easy to test - the parameters will appear when you click on "view data"

Regards
Peter

sdevashis · Post by **sdevashis** » Wed Dec 17, 2003 2:50 am

Thanks Peter.

roy · Post by **roy** » Wed Dec 17, 2003 4:59 am

Hi,
I noticed you mentioned mail server,
since the mail notification stage doesn't support parameters,
if you need them you can use the DSSendMail routine (or the tester routine) in order to get parameters.

FYI, in case you have no problem with fixed values you can use the tools>options in the designer to set default values for this stage, this means that every notification stage you place wouls have them.

IHTH