calling stored procedure from data connection wizard

[Patrick Temple]

I created a stored procedure that inserts a row and returns the max(id) for
the table.
How do I call this procedure in the data connection wizard. I edited the
sql statement with:

exec "dbo"."addnewId"

When I test the sql I get the following error:

The ADO Adapter failed to get the schema.
The query does not return a recordset. Please check the SQL statement.

In SQL Query Analyzer it works just fine. So it has to have something to do
with the connection wizard syntax.

 

[Elridge]

I think that the query in the data connection wizard is used to generate an
xml schema of the data source. My guess is that if your stored procedure
does not return the appropriate information, InfoPath will give you the error
message that you got, as it does not have enough info to create an
appropriate xml schema.

-Elridge