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???
Hard Code User Name and Password & Mail server
Moderators: chulett, rschirm, roy
Hard Code User Name and Password & Mail server
/*Devashis*/
-
- Participant
- Posts: 20
- Joined: Thu Nov 27, 2003 3:45 am
- Location: New Delhi, India
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
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
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
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
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
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
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org