Data Connections

Re: Web Service or ADO connection

liorlankri — Thu, 10 Aug 2006 07:20:56 GMT

Thank you!

Re: Web Service or ADO connection

Abhishek — Tue, 08 Aug 2006 14:03:41 GMT

Hi Liorlankri,
I use web services because it helps me create modules of code.

If any changes need to be done to the code in webservice,the InfoPath form need not be republished again.

It really helps me since I use regform to make my form full trust and deploying such a form in sharePoint needs a work around.
So publishing each and every time I make a change to the code is a tedious job.

So in case of webservices to access databases or SAP Bapis,I can easily modify my queries in the webservice.No touching InfoPath code is required.

regards,
Abhishek

Re: Web Service or ADO connection

liorlankri — Tue, 08 Aug 2006 04:43:29 GMT

I know how to operate the Web Service from my code. That was not my question

Re: Web Service or ADO connection

Kalyan Gaddam — Thu, 03 Aug 2006 10:39:22 GMT

Hello

Please read Level 400 exercise in the Link below
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_ip2003_tr/html/odc_INF_Lab_08.asp

I hope it will help you.

Web Service or ADO connection

liorlankri — Thu, 03 Aug 2006 04:33:10 GMT

I have InfoPath form and I design it by New Blank Form.

My form contain a Text box and I want on the OnAfterChange event to chek if this value already exist in the DataBase.

Sould I use Web Service or can I use simple VBscript or JSscript code for ADO connection:

var conn = new ActiveXObject("ADODB.Connection")
and the to write me SQL query.

When to use this and when to use Web Service???