Avatar of Netlink2
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 ?.
Web Languages and StandardsVisual Basic.NET

Avatar of undefined
Last Comment
Netlink2

8/22/2022 - Mon
Netlink2

ASKER
I just noticed that if I create a new connection which uses a different table then I can get the option the first time I use it.

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 ?.
ASKER CERTIFIED SOLUTION
armoghan

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Netlink2

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

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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Netlink2

ASKER
Oops, that post was meant to go somewhere else.