I created a form in info path which will connect to SQL DB and all connectivity are fine. I preview the form and all SQL data retrieved fine without any issue.
I published the form but when end-users try to load the form, it was shown an error like (An error occurred querying a data source. An error occurred while using the form. For more information, contact the site administrator).
Means I can only retrieve the data while I am at info path and previewing the form but not after the publish.
Is there any things which need to be allowed at SharePoint level to connect to connect to SQL DB which I used in the info path.
Please help and advice .. what could be the issue ??
I would think about permissions on the database. Have you tried to access the form from the browser with the same user you used in InfoPath designer?