# ADO Execute SQL doesnt save password

**URL:** https://www.finalbuilder.com/forums/t/ado-execute-sql-doesnt-save-password/3556
**Category:** Bugs
**Created:** [February 12, 2015, 9:26am UTC](https://www.finalbuilder.com/forums/t/ado-execute-sql-doesnt-save-password/3556 "2015-02-12T09:26:45Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![llandr](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/l/a9adbd/32.png) [@llandr](https://www.finalbuilder.com/forums/u/llandr)
#### Post date: [February 12, 2015, 9:26am UTC](https://www.finalbuilder.com/forums/t/ado-execute-sql-doesnt-save-password/3556/1 "2015-02-12T09:26:45Z")

</div>

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).

---

<div class="post-metadata">

### Author: ![nevar](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/n/c4cdca/32.png) [@nevar](https://www.finalbuilder.com/forums/u/nevar)
#### Post date: [February 12, 2015, 11:05am UTC](https://www.finalbuilder.com/forums/t/ado-execute-sql-doesnt-save-password/3556/2 "2015-02-12T11:05:06Z")

</div>

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](http://stackoverflow.com/questions/17088676/promptdatasource-and-password)

---

<div class="post-metadata">

### Author: ![llandr](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/l/a9adbd/32.png) [@llandr](https://www.finalbuilder.com/forums/u/llandr)
#### Post date: [February 17, 2015, 8:05am UTC](https://www.finalbuilder.com/forums/t/ado-execute-sql-doesnt-save-password/3556/3 "2015-02-17T08:05:44Z")

</div>

Thank you. Changing provider solved my problem.