N
NetDoc
I am attempting to use Infopath for data entry of two (2) different sets of
data. I am storing the Infopath form data as an XML datatype in SQL Server
2005 tables – two separate tables, each table has 2 columns – ID
(auto-incrementing integer) and XMLData (xml datatype).
I have a Stored Procedure to retrieve the data from the XMLData column:
CREATE PROCEDURE getData
AS
SELECT XMLData FROM table1
GO
I have an HTTP EndPoint:
CREATE ENDPOINT getDataEndPoint
STATE = STARTED
AS HTTP(
PATH = ‘/demo’,
AUTHENTICATION = (NTLM),
PORTS = (CLEAR),
SITE = ‘server’
)
FOR SOAP (
WEBMETHOD ‘getData’
(name=’demoDB.dbo.getData’,
SCHEMA=STANDARD),
WSDL = DEFAULT,
SCHEMA = STANDARD,
DATABASE = ‘demoDB’
)
GO
When I attempt to use the XMLData (generated via Infopath form #1) from SQL
Server as a secondary data source in Infopath form #2, Infopath perceives the
returned data as pure text and does not recognize it as XML. This occurs
both when I configure the secondary connection as a database connection with
the execution of the stored procedure and when I configure the secondary
connection as a Web Service.
Infopath can obviously understand XML structures with secondary connections
since this works with a simple XML file.
Am I missing a schema definition somewhere? Or, is this not supported in
Infopath?
Thanks for any assistance,
data. I am storing the Infopath form data as an XML datatype in SQL Server
2005 tables – two separate tables, each table has 2 columns – ID
(auto-incrementing integer) and XMLData (xml datatype).
I have a Stored Procedure to retrieve the data from the XMLData column:
CREATE PROCEDURE getData
AS
SELECT XMLData FROM table1
GO
I have an HTTP EndPoint:
CREATE ENDPOINT getDataEndPoint
STATE = STARTED
AS HTTP(
PATH = ‘/demo’,
AUTHENTICATION = (NTLM),
PORTS = (CLEAR),
SITE = ‘server’
)
FOR SOAP (
WEBMETHOD ‘getData’
(name=’demoDB.dbo.getData’,
SCHEMA=STANDARD),
WSDL = DEFAULT,
SCHEMA = STANDARD,
DATABASE = ‘demoDB’
)
GO
When I attempt to use the XMLData (generated via Infopath form #1) from SQL
Server as a secondary data source in Infopath form #2, Infopath perceives the
returned data as pure text and does not recognize it as XML. This occurs
both when I configure the secondary connection as a database connection with
the execution of the stored procedure and when I configure the secondary
connection as a Web Service.
Infopath can obviously understand XML structures with secondary connections
since this works with a simple XML file.
Am I missing a schema definition somewhere? Or, is this not supported in
Infopath?
Thanks for any assistance,