Currently when I create a form I have to enter my SQL connection string in two sections on the Dynamic Forms Control Panel(External DB Connection and Database Provider Connection String). I have multiple forms and 4 environments to deal with. Is there a simpler way that allows me to do this at a global DNN level so that each time I build new forms and put them onto different environments I do not have to update my SQL connection string each time. Also, I do not like having the SQL login information so visible so if there is something I can do to make the more secure I'd appreciate the information. Thanks for any advice you can provide.
|