General

Re: Submit to DB via Web Service

mdsmitty — Tue, 28 Jun 2005 17:04:28 GMT

Thanks Jim, we'll give this a shot.

Re: Submit to DB via Web Service

jimbob — Tue, 28 Jun 2005 16:01:50 GMT

With XP using IIS5.x, use the Application Protection option on the 'Home Directory' or 'Directory' tab in the website properties pages. If you configure for "Low (IIS Process)", the SYSTEM account is used, and you will need to give the SYSTEM account database access (assuming the DB is on the same machine).

Jim Cantwell
InfoPathDev Redmond

Re: Submit to DB via Web Service

mdsmitty — Tue, 28 Jun 2005 12:19:48 GMT

Thanks Patrick. Let me know where I can get the new setup.txt when it is available.

Smitty

Re: Submit to DB via Web Service

Patrick Halstead — Tue, 28 Jun 2005 05:59:24 GMT

Hi again Smitty,
You need to install IIS on the box. I know you can do this on WinXP Pro, but I forget the details. I'll ask Jim to respond and make sure to get the setup.txt fixed tonight. Thanks for the feedback!

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Submit to DB via Web Service

mdsmitty — Mon, 27 Jun 2005 12:57:38 GMT

Patrick,
How would the Database Accelerator run on XP Pro. I can't find the Application Pools in Internet Information...I found it on 2003 but not on XP. Is there a different set-up on XP? If you have a different set of set-up instructions for XP please let me know where I can locate them.

Thanks
Smitty

Re: Submit to DB via Web Service

mdsmitty — Fri, 24 Jun 2005 12:43:34 GMT

Thanks Patrick, I'll give this a shot and let you know how it turns out.

Thanks again
Mdsmitty

Re: Submit to DB via Web Service

Patrick Halstead — Fri, 24 Jun 2005 01:44:27 GMT

Hi MdSmitty,
Yes, check out the eval version of our Database Accelerator. It allows you to do this without writing any code. It's in Free Downloads.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Submit to DB via Web Service

mdsmitty — Thu, 23 Jun 2005 20:06:13 GMT

PS

I created the form from a data connection which is also populating other info on the form.

Submit to DB via Web Service

mdsmitty — Thu, 23 Jun 2005 19:28:21 GMT

hi all,

I have a form which I want to use to submit data entry info to a database table. When I attempt this I am unable to select "Database" from the submit options menu as well as from any Rule.

Example:
The user is filling in a Repeating Table which I would like to submit to a database table. I don't want the information being stored to be viewed again by this particular form. Basically this portion of the form is being used for data entry only.

Is it possible to submit the data from the Repeating Table to a Web Service and then pass the data on to a database?