The password is not saved in the action ADO Execute SQL.
In the Windows “Data Link Properties” the password is not save when checking “Allow saving password”.
It always reverts to “Blank password” when closed.
FB version: 7.0.0.3202
Windows: 8.1 Pro
Connecting to SQL Server (dont know the exact version).
Hi Jonas,
Thank you for reporting this. The current control we are using (A Windows “Data Link Properties Dialog Box”) seems to have this behavior built in. We simply pass the built connection string to it, and it fills in the controls based on this value. From what I have reproduced this value doesn’t seem to be loaded from the information we give to it. Meaning at this stage you would have to re-enter it time.
Also depending on the provider/driver your using, some do not work with saving passwords. This stackoverflow post might be of some use.
http://stackoverflow.com/questions/17088676/promptdatasource-and-password
Thank you. Changing provider solved my problem.