ODBC source

[NewsArchive]

Hi,
How can I change an ODBC source password?
TIA

--
*Alberto Michelis*
ARMi software solutions www.armi.com.ar <http://www.armi.com.ar>

<http://www.portfoliofinanciero.com.ar>

[NewsArchive]

Alberto,

> How can I change an ODBC source password?

How would you do it without SetupBuilder? Then try to repeat those steps
using your SetupBuilder app.

BTW, for security purposes, Microsoft does not store passwords in ODBC DSN
settings.

Friedrich

[NewsArchive]

THanks Friedrich... and where are stored those passwords?

Alberto Michelis

[NewsArchive]

Hi Alberto,

>
> THanks Friedrich... and where are stored those passwords?
>

It completely depends on the ODBC driver, so you have to contact the vendor
of the ODBC driver. But most drivers do not "store" it at all in plain text
and the user ID and password used to create the ODBC are not stored anywhere
with the ODBC.

IIRC, early versions of the MySQL ODBC drivers store the password in the
registry/ODBC.INI

HKLM\Software\ODBC\ODBC.INI\<name of your system ODBC source>

Not sure if this is still the case.

But for most ODBC drivers, the password is "hashed" and not accessible as
clear text.

Friedrich