The problem: When accessing a SQL table or view from a browser enabled InfoPath Form gives you an error Data adapter failed during OnLoad
This happens when using a dataconnection to a SQL server using a .udx file.
To solve this you need to have Enable embedded SQL authentication checked. Also if your SQL runs on another server you need cross domain acces. So make sure that Allow Cross-domain data access for User Form Templates is checked.
Change these settings in Central Administration/Configure InfoPath Forms Services
Do you for some reason you would like to have a landingpage to be displayed before a visitor enters the SharePoint site? This post gives an option to do just that.
What we need to do is to set a new folder where visitors “land”. There you will have created an index.html that suits you.
First make sure your new index.html is ready and works fine. On that page you can add a link back to the SharePoint site. (I used /Pages/Default.aspx)
You can test your new page by entering /LandingPage/Index.html after the url of your SharePoint site. (http://www.contoso.com/LandingPage/Index.html)
To set the new folder we’re going to edit the web.config of the SharePoint site. You can find this file in the <systemdrive>\inetpub\wwwroot\wss\VirtualDirectories\<sitename>
But remember to make backup copies before making any changes.
Right under <system.web> enter these three lines:
<add url=”~/” mappedUrl=”/LandinPage/Index.html”/>
ReplaceLandingPage/Index.html with the folder and name of your html page.
Save the web.config and restart the iis. (iisreset from the command prompt)