SharePoint User Group UK

Hi All,

I have created a couple of browser enabled InfoPath forms which read data from a SQL database OK and display the relevant information - took a while!

Anyway now I'm getting very excited (sad I know) and would like to be able to send data back into SQL from my form which users will fill in.  I'll then be able to report on this information etc etc.  I presume using web services is the way to go in this case, has anyone got an idot's guide how to do this?  When I say how to this I mean setting up the webservice, I think I've got the hang of InfoPath design.

Thanks!

Hi

You could submit the data back to the SQL server using the data connecitons you have already created to get the data or if you want to use the web service route these may help give you some idea:

http://weblog.vb-tech.com/nick/archive/2007/01/12/2088.aspx

http://weblog.vb-tech.com/nick/archive/2007/01/17/2100.aspx

---

Andrew Carter
.Net & SharePoint

Hi Andrew,

As the forms are rendered in a browser, I can't save the data back into SQL.  I'll take a look at the web service route links.  Thanks very much!

Regards

Have a look here:

http://blogs.technet.com/elenat/archive/2008/05/13/designing-an-infopath-form-that-can-store-data-in-a-database-part1.aspx

Cool!

Thanks for the info.  I will take a look.

Regards

If you're still working on this one of my collegues has posted on this subject...

See the blog here...or let me know if you need any help...

Rgs,

Steve

Hi all,

OK, I have finally had some time to sit down and go through this.  Everything seems to be OK and I have created my HTTP endpoint OK.  However, when I try to connect to the web service, I get the error "The file is not a valid XML file.  Not enough storage is available to process this command."

To connect, via InfoPath I am using http://myservername:2000/sql and then hitting the next button to try to find the file

I created my HTTP endpoint by using this script:

CREATE ENDPOINT discount_endpoint

STATE = STARTED

AS HTTP (

PATH = '/sql',

AUTHENTICATION = (INTEGRATED ),

PORTS = ( CLEAR ),

SITE = 'myservename',

CLEAR_PORT = 2000

)

FOR SOAP (

WEBMETHOD 'StoreDiscountData'

(name='infocityhall.dbo.StoreDiscount',

SCHEMA=STANDARD ),

WSDL = DEFAULT,

SCHEMA = STANDARD,

DATABASE = 'infocityhall',

NAMESPACE = 'http://tempURI.org'

)

The script was from

http://blogs.technet.com/elenat/archive/2008/05/13/designing-an-infopath-form-that-can-store-data-in-a-database-part1.aspx

Any ideas?  I have tried to reserve port 2000 especially, just in case port 80 is being used by another application.  I have checked that the web service is running.

PS, Yes I did replace myservename with my actual server name !

You said you tested the webservice and it works but you cannot connect via Infopath. Have you tried with http://yoursqlservername/sql?wsdl (i.e. adding wsdl at the end)?

Hi elenat,

Thanks for your suggestion, I did have WSDL on the end of my connection string.  I decided to double check the event logs on my server and found "HTTP authentication failed. [CLIENT: xxx.xx.xx.xxx]"

I then did a bit of google searching and came across this http://blogs.msdn.com/infopath/archive/2006/12/20/using-sql-server-2005-web-services-with-infopath.aspx

I changed my authentication to NTLM (after dropping and re-creating my endpoint) and it all worked fine!

Cheers

Rikky