I have four database queries in my infopath form. Three of these populate drop-down list boxes and the data is retrieved at load time. For the fourth one, I'm using a ADOQueryConnection to modify the command associated with the data connection dynamically when a button in the form is pressed.
I can successfully publish this form and invoke it within InfoPath and everything works just fine. However, when i publish the form to a forms server and open the form in a browser, everything is ok and all data connections work except the one that I am dynamically modifying. It does not return the data results. I have verified the form in design checker and there are no issues. The form is fully trusted (signed) and I've admin installed the form on the server. Browsing other posts here i saw suggestion to look athe log and I did. Here's the error i see: "Failed to determine definition for Feature with ID .....". I'm not sure how this is relevant.
Below are the XML results captured for these two situations. Can anybody help? thanks
When form is invoked in infopath:
<dfs:myFields xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"><dfs:dataFields> <d:per xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields" PER_NM_LAST="First_Name" PER_NM_FIRST="LAST_NAME" INV_BIR_DT="1985-06-12T00:00:00" CS_XPG_DT="2008-01-01T00:00:00" PER_NEEDS_INTERP="True" PER_LNG_CD="ALBA" PER_ID="11111" CS_ID="1"/> </dfs:dataFields></dfs:myFields>
When form is invoked in browser:
<dfs:myFields xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"> <dfs:dataFields xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" /> </dfs:myFields>