Re: database connection in browser enabled form

kaleo — Tue, 01 May 2007 06:27:55 GMT

I thought web enabled forms were great! but when i started designing them i noticed that they just aren't as powerful as i thought....

Below is a link that outlines the incapabilities of InfoPath 2007 Web Enabled Forms...

http://office.microsoft.com/en-us/infopath/HA102105871033.aspx

I'm not sure if you're problem is in here but it may be a good place to start....

Kaleo

database connection in browser enabled form

mshukla — Tue, 01 May 2007 05:33:05 GMT

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>

Browser Forms

Re: database connection in browser enabled form

database connection in browser enabled form