Gentlemen,

I have a problem that some of you might have been faced with as well.

On several workstations (NT4 Workstation SP6a) an ODBC data source is
defined for an application called BAAN (might sound familiar), which
uses an MS SQL server. The ODBC data source has a password on it to
make sure not everyone can log on to the BAAN server. The username and
password of the ODBC data source is the NT password, which is
automatically verified at the PDC, so every time people have to change
their NT password (due to password policy settings), the ODBC data
source password has to be changed as well... manually!

You can imagine that people make (lots of) mistakes when changing
their passwords. As a result the service desk is bothered with users
complaining about connectivity problems to the BAAN server.

Does anyone know of a tool that automatically changes the encrypted
ODBC password of a particular ODBC data source when the NT password is
being changed (in the registry key HKCU\Software\ODBC\ODBC.INI\<data
source>\)? Or an application that which automatically shows a window
saying that the ODBC data source password has to be changed as well,
with two text areas in which to type the password and a confirmation
of that password?

I've been searching the web, but nothing came up!

Thanks in advance,

Casper.

PS: My apologies if I posted to the wrong newsgroup. This one seemed
as close as I could get.