Infopath forms saving data to SQL 2000 table

[Shakeel]

We have third party dot net application where all the InfoPath forms are
stored in a SQL database, however we are adding some forms (using web service
to retrieve some data from their SQL database) and need to save the data back
to another SQL database in a table for using it in SQL Reporting Service, I
know it is possible thru custome code in the form, is there any tutorial or
step by step instructions how to do that, will appreciate any help.

 

[Clay Fox]

What is the third party application?

I thought most could also save data to SQL along with the form itself.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Shakeel]

Sorry for misunderstanding. It is a custom application by a third Party
where they perform the backend SQL database administration and customization
and reporting from InfoPath Forms. We wanted to save the InfoPath forms to
our SQL database so we can produce our reporting. I wanted to write the data
directly to a SQL table instead of XML which I am not much familiar at the
moment, I know it is possible thru backend VB custom coding, but don't know
how to do it, is there any tutorial/direction on how to write data from
InfoPath forms to a SQL table directly. Thanks.

 

[Clay Fox]

To submit to SQL would take creating web services or downloading installable
web services such as the Database Accelerator Package from
http://www.qdabra.com

It stores the forms in SQL but also provides shredding so that the fields of
the form can be extracted and saved in additonal databases like you are
looking for.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com