Re: Mysql/MyODBC - windows password in the clear

[Jonathan Lampe]

Under Windows 2000, ODBC-configured passwords can be found in the clear under the ODBC.ini registry key.

Under Windows 2003, you need to work a little harder to fish passwords out of ODBC settings (e.g., OneProp = (ADODB.Property) ODBCConn.Properties["Extended Properties"];), but they are still there in the clear if you know what you're doing.

I don't know much about Access, but if you are using any sort of environment that has a programmable interface, you should be able to store your ODBC credentials in an encrypted string instead and only present them when you connect.