SQL Database Integration

Re: Receive data from SQL to browser enabled form

jeeva — Tue, 04 Nov 2008 13:50:05 GMT

Hi Friends,

Thank u very much for yours solution.

I solve my issue by changing the cross-domain property in central admin.

Re: Receive data from SQL to browser enabled form

santhoshp — Tue, 04 Nov 2008 06:44:34 GMT

Hi,

You should have a method in your web service to receive data from database. Then you have to take the receive data connection in your IPF to that web method.

Here is one example for creating a http endpoint web service which has a web method to receive data from a table in database.

--Stored Procedure for receiving data from a table in database

create procedure Receive

Begin

select * from dbo.DISCOUNTS

end

--Create a web service by using the stored procedure for receiving data

Create ENDPOINT discount_endpoint_Receive

STATE = STARTED

AS HTTP (PATH = '/sqlreceive',

AUTHENTICATION = (INTEGRATED ),

PORTS = ( CLEAR ),

SITE = 'server14')

FOR SOAP (WEBMETHOD 'ReceiveData'

(name='infocityhall.dbo.receive',SCHEMA=STANDARD ),

WSDL = DEFAULT,

SCHEMA = STANDARD,

DATABASE = 'infocityhall',

NAMESPACE = 'http://tempUri.org/')

Now we have to take receive data connection for "ReceiveData" method in "http://server14/sqlreceive?WSDL" web service.

Re: Receive data from SQL to browser enabled form

sandhyapati — Tue, 04 Nov 2008 06:10:39 GMT

Hi jeeva,

can you go through the below links, I hope it gives clear idea

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

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

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

Receive data from SQL to browser enabled form

jeeva — Tue, 04 Nov 2008 05:07:25 GMT

I created one browser enabled IPF, it contains 5 textfields (Name,Class,Subject,ID,Date).

I created one database in my sql server.

How can i receive sql data from my IPF using webservice.

If anyone knows the solution give me some examples.