Consider the following scenario:
| • | In Microsoft SQL Server 2005, you create a Web service endpoint for a stored procedure. |
| • |
The stored procedure takes parameters.
|
| • | In Microsoft Office InfoPath 2007, you create an InfoPath form template that is based on this Web service. |
In this scenario, InfoPath 2007 cannot infer the correct schema or any schema for the data fields. Only a group node appears at the dataset level.
Back to the top
This problem occurs because you did not enter sample values for the required parameters when you designed the data connection in the Data Connection Wizard.
Back to the top
To work around this problem, modify the data connection in the Data Connection Wizard. Enter sample values for the required parameters, and then finish the wizard.
Note If you use the
?wsdlsimple parameter in the Web service, InfoPath 2007 cannot infer the full schema for the Web service unless you specify the ROWSETS_ONLY value in the endpoint definition.
Back to the top