https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/124596.aspxMon, 06 Dec 2021 15:54:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124596Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/124596.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=124596Have your SharePoint admins check the ULS logs. It is likely that there is a setting that needs to be changed in Central Admin - there is a setting for allowing UDCX with stored credentials with browser forms: SharePoint Central Admin ->general application settings-> Configure InfoPath Forms Services. Check the box next to Allow embedded SQL authentication.https://www.infopathdev.com:443/forums/thread/124594.aspxMon, 06 Dec 2021 13:51:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124594Janine0https://www.infopathdev.com:443/forums/thread/124594.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=124594Hello! I have an infopath form that needs to query countries from an Oracle DB. I made the web connection using the 'Database MS SQL Server only' option in the wizard and selected what needs to be pulled from the DB but it seems to only work in preview mode. When I open the form in the browser, I get a msg saying that ' An error occurred querying a data source'. I noticed when I go in to edit the data connection it states "The selected DB connection saves passwords in a plain text file. Because plain text files are unencrypted and because the DB connection is available to anyone using your InfoPath form, this action is not recommended." Is that a problem? I also have the "Automatically retrieve data when form is opened" selected (check box at end of wizard), but it only allows the form to work in Preview mode (countries display) and not the browser (countries don't display). Could that be an issue as well? One more thing... when I do leave the "Automatically retrieve data when form is opened" selected, it prompts the same message for existing forms but when I uncheck the box and republish it, the existing forms and the original template used no longer prompts with the message "An error occurred querying a data source". Not sure what I'm doing wrong... help?