The "SQL Database" option for Prevalue Sources has two fields for connections, one just called "Connection String" and another one called "Connection String from web.config".
For some reason, that is not obvious to me, both of them have to be filled out and it seems to always default to the "Connection String" and never use the "Connection String from web.config".
Hi Christian
Having a similar problem myself - would rather not have the connection string in plain text within the cms but pull it from the web.config have you found a way around this?
just started using the sql database prevalue source in a project. it works really well but having the raw connection string showing in the backoffice is far from ideal...
fingers crossed it'll be an easy one for them to sort!
Prevalue Source - SQL Database - Connection String from web.config
The "SQL Database" option for Prevalue Sources has two fields for connections, one just called "Connection String" and another one called "Connection String from web.config".
For some reason, that is not obvious to me, both of them have to be filled out and it seems to always default to the "Connection String" and never use the "Connection String from web.config".
What is the logic behind this if any?
Hi Christian Having a similar problem myself - would rather not have the connection string in plain text within the cms but pull it from the web.config have you found a way around this?
Unfortunately no, this piece of functionality never seems to have been implemented correctly in Umbraco.
hey there,
just found this thread after trying to get a sql database prevalue source working...
having to enter the connection string rather than selecting it from the web.config is fairly major security issue!
i'm searching on https://github.com/umbraco/Umbraco.Forms.Issues/issues but not seeing anything reported...
it might not've been fixed yet as they don't know about it?! assuming i'm looking in the right place that is...
I don't think it has ever been fixed / implemented.
i've chucked it in as an issue:
https://github.com/umbraco/Umbraco.Forms.Issues/issues/223
just started using the sql database prevalue source in a project. it works really well but having the raw connection string showing in the backoffice is far from ideal...
fingers crossed it'll be an easy one for them to sort!
Agreed. And they started updating forms again, so lets cross our fingers.
is working on a reply...