Web Service - Technical Question

[Kevin]

I need to interface an Infopath form with a velocis database....

I am able to write programs with C++ for velocis, so I would be able to
create a "web service" I believe.

I would be running this as an ISAPI dll.

What I need to know is what is infopath expecting from a web service in
order to interface with it. What data format / protocol is it expecting to
see?

 

[Scott L. Heim [MSFT]]

Hi Kevin,

Your web service will need to return a dataset to be consumed by InfoPath.
The following is a link to an InfoPath/web service lab:

Lab 9: ADO.NET DataSets in InfoPath 2003
http://msdn.microsoft.com/office/understanding/infopath/training/default.asp
x?pull=/library/en-us/odc_ip2003_tr/html/odc_inf_lab_09.asp

Hopefully this will provide more insight to designing a web service for
InfoPath. In addition, here are 2 basic VS.NET (C#) procedures that will
return and update data from the Customers table in the Northwind sample
database on SQL Server:

[WebMethod]
public DataSet GetCustomers()
{
daCustomers.Fill(dsCust);
return dsCust;
}

[WebMethod]
public void UpdateCustomers(DataSet ds)
{
daCustomers.Update(ds);
ds.AcceptChanges();
}

** NOTE: I had previously created the connection, data adapter (daCustomers
as simply SELECT * FROM Customers) and dataset (dsCust) in the designer.

I hope all this helps!

Best regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.