Code

Re: Submitting Form data to MS SQL Server 2000 DataBase

Greg Collins — Fri, 08 Jun 2007 19:19:15 GMT

Great! Good job! Glad to hear you got it working.

Re: Submitting Form data to MS SQL Server 2000 DataBase

pskaushik — Fri, 08 Jun 2007 04:57:41 GMT

Thanks Greg.

I made a data field Primary key in Database and then its working.

thanks for your help.

Pushpendra

Re: Submitting Form data to MS SQL Server 2000 DataBase

Greg Collins — Thu, 07 Jun 2007 21:10:40 GMT

Not sure why you are not getting the option. Some designs are not supported in InfoPath.

Try designing a new form based on a SQL connection to a very simple single table)... i.e. nothing fancy - no table linked to another table, etc.

If this works, then check to make sure the design you are creating in your sql query string for connection is supported.

In case you didn't choose to design your form based on a sql connection, try going that route first. This is different than adding a sql connection later.

Re: Submitting Form data to MS SQL Server 2000 DataBase

pskaushik — Thu, 07 Jun 2007 05:50:09 GMT

hi,

I have tried first method of the list i.e. 1. "Create a form which has its main data source bound to the database tables. Then submit is straight forward"

.But on Submit option, only following three methods are comming in dropdown.

Submit using WebService

Submit Through HTTP

Submit using Custom Script

There is no option comming to select database.

is it a problem related to version of InfoPath?

For Receivig, Database option is comming but for submit its not comming.

Please reply asap.

Thanks

Pushpendra

Re: Submitting Form data to MS SQL Server 2000 DataBase

Greg Collins — Wed, 06 Jun 2007 16:32:49 GMT

1. You can create a form which has its main data source bound to the database tables. Then submit is straight forward.

2. You can write a Web service which submits the data to the database... will likely require some form code as well.

Submitting Form data to MS SQL Server 2000 DataBase

pskaushik — Wed, 06 Jun 2007 10:36:22 GMT

hi,

I am new in InfoPath Development.

can any one tell me how can we save InfoPath2003 form data to MS Sql Server Data base?

Please help me if some one has idea on this.

Pushpendra