Changing DB2 Passwords in VB

DB2 for OS/390

"mark" <mknuttall@nospam.com> wrote:
>
>Which Edition (Win,Unix,MF,AS400)?
>
>If windows, as far as I can tell, permissions come from windows security
>so they should just change their windows password.
>
>Mark
>
>"Tim Burke" <tim_burke@pepboys.com> wrote:
>>
>>Is there a way through ADO parameters, a DLL, or 3rd party software to
allow
>>a user to change their password for DB2?
>>
>>Any help would be greatly appreciated
>>
>>THanks,
>>Tim Burke
>

Probably RACF. And I highly doubt it. We couldn't do it a few years ago.
MF security managers typically don't like anything done outside the box
- literally or figuratively. Good luck. Hope I'm wrong.

Mark

"Larry" <lsedels@us.ibm.com> wrote:
>
>"Tim Burke" <tim_burke@pepboys.com> wrote:
>
>You'll need to find out what product is being used for authentication on
>the
>390 and then ascertain whether there are programatic APIs to change the
password.
>
>Larry Edelstein
>
>
>>
>>
>>DB2 for OS/390
>>
>>
>>
>>"mark" <mknuttall@nospam.com> wrote:
>>>
>>>Which Edition (Win,Unix,MF,AS400)?
>>>
>>>If windows, as far as I can tell, permissions come from windows security
>>>so they should just change their windows password.
>>>
>>>Mark
>>>
>>>"Tim Burke" <tim_burke@pepboys.com> wrote:
>>>>
>>>>Is there a way through ADO parameters, a DLL, or 3rd party software to
>>allow
>>>>a user to change their password for DB2?
>>>>
>>>>Any help would be greatly appreciated
>>>>
>>>>THanks,
>>>>Tim Burke
>>>
>>
>

If you're using an ODBC connection and a DSN you should be able to append
the NEWPWD parameter to the end of your connection string.

ex: ConnectionString =
"ODBC;DSN=DB2DSN;UID=xxxx;PWD=OLDPASS;NEWPWD=NEWPASS"

This worked fine with DB2Connect 5.2, broke in 6.1 in some situations, and
haven't tried it yet with 7.x

Nick

"Kevin" <kn2642@ctmail.snet.com> wrote in message
news:3b3bbe0e$1@news.dev-archive.com...
>
> "Tim Burke" <tim_burke@pepboys.com> wrote:
> >
> >Is there a way through ADO parameters, a DLL, or 3rd party software to
allow
> >a user to change their password for DB2?
> >
> >Any help would be greatly appreciated
> >
> >THanks,
> >Tim Burke
>
> I recently struggled with the same question - and the answer is yes. I
access
> DB2 on OS/390 with RACF security using DB2 Connect from IBM. To change a
> password it is necessary to use the Call Level Interface in the ODBC
library.
> I can't remember the exact function name but if you're interested and you
> have DB2 Connect send me an email.