delphi - TAdoConnection password goes AWOL -

using tadoconnection in d5 connect local sql server on windows 7 64-bit machine using passworded sa account, error "login failed user sa", despite fact i've built tadoconnection connectionstring include password. time beforeconnect event triggers, connectionstring no longer contains password. can set password in willconnect event , connection works fine.

my question is, what's removing password connectionstring? maybe security feature added in w7 - don't recall getting problem on xp.

btw: problem still happens if set persist security info true in connectionstring - password doesn't stored in dfm.

your connectionstring needs include "persist security info=true" see prior topic. use 2 const, 1 sql authentication , other active directory authentication , fill in blanks.

const   csconnection   = 'provider=%s;password=%s;persist security info=true;user id=%s;initial catalog=%s;data source=%s';   csadconnection = 'provider=%s;integrated security=sspi;persist security info=false;initial catalog=%s;data source=%s';