Netlink2
asked on
include sensitive data in the connection string
Hi experts, I hope someone can help me with this. In the TableAdapter Connection Wizard, the option "include sensitive data in the connection string" isn't enabled. How can I enable this so I can select it ?. I want to be able to save a password in the ado connection string, but can't do this. Alternatively is there any way to edit the connection string in the datatable ?.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for that, I also found you can delete it from server explorer data connections. I'm suprised it took so long to get an answer to such a simple question. In any case, thanks again.
ASKER
Found the answer.
The sting is present at two places ,
1. app.config file in solution explorer under the tag
<connectionStrings>
2. Setting file in Solution explorer
3. Delete it from server explorer data connections.
The sting is present at two places ,
1. app.config file in solution explorer under the tag
<connectionStrings>
2. Setting file in Solution explorer
3. Delete it from server explorer data connections.
ASKER
Oops, that post was meant to go somewhere else.
ASKER
But if I try to use the same table again it appears as a Data Connection and I can't change the connection string options.
How can I delete the old connection/s in the list or modify an existing connection ?.