SQL Database Integration

Re: XML: MS Rowset Schema

Mojo Texas — Fri, 07 Mar 2008 09:57:41 GMT

Fox,

thanks for the reply. In answer, I am not using SQL server version, so no interface there. Also, not using Web Services. In fact, my iBase database is in a standalone secure environment, it's all by itself on a dedicated machine. If you want to put something in there, you have to drag it over on a USB stick.

Is there any way of transorming the schema from InfoPath's native output to the required MS Rowset? (possibly using XSLT?)

Re: XML: MS Rowset Schema

Clay Fox — Thu, 06 Mar 2008 18:02:34 GMT

You may have to create a specific XML file that would be used as the interface.

Can you interface between SQL and iBase?

You could maybe export to SQL and then have an integration routine which moves the data to iBase.

Does it work with web services?

XML: MS Rowset Schema

Mojo Texas — Thu, 06 Mar 2008 09:33:48 GMT

I am working with iBase, an visual analysis database. iBase loves to import data, and infopath loves to collect data, so I'd like to use them together. InfoPath outputs XML and iBase loves XML, so it should be a natural match. However, iBase will only import XML formatted as "MS Rowset Schema". So, when I make an infopath form, I cannot import the XML it produces.

How can I format my XML output to conform to the MS Rowset Schema?