Hello!
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?