Connection With InfoPath 2007 to SQL2005 through Endpoints Error

[jalalin7]

Hi,
Scenario:
OS=Windows 2003 ent.
DB= Sql 2005

Wss 3.0
Moss2007
InfoPath2007

I want to create a connection from InfoPath to SQl through the web service
endpoints.

In SQL:
1) I have created a procedure
CREATE PROCEDURE usp_SubmitInfoPath

@FirstName varchar(50),
@LastName varchar(50),
@Address varchar(50),
@City varchar(50),
@State varchar(50),
@ZipCode varchar(50),
@PhoneNumber varchar(50)

AS

Insert Into IP_WS_Submit (FirstName, LastName, Address, City, State,
ZipCode, PhoneNumber)
Values (@FirstName, @LastName, @Address, @City, @State, @ZipCode,
@PhoneNumber)

2) Created an endpoint tied to the above procedure
Create Endpoint IPWS
State= started
As Http(
Path='/sql/test1',
Authentication=(ntlm),
Site='SQL2005',
Ports=(Clear)

)
For Soap
(
WEBMETHOD 'usp_SubmitInfoPath'
(
name='AdventureWorks.dbo.IP_WS_Submit',
Schema=Default,
Format=Rowsets_only
),
Batches= disabled,
WSDL=Default,
Database='AdventureWorks'
);
GO

Then if I try to make a web service in InfoPath using the url:
http://sql2005/sql/test1?WSDL

I get the following error:
WSDLPortort IPWS has no operations HRESULT=0x1: Incorrect function.
- WSDLServicerocessing service IPWS found no port definitions
HRESULT=0x80070057: The parameter is incorrect.
- WSDLReader:Analyzing the WSDL file failed HRESULT=0x80070057: The
parameter is incorrect.

Any Suggestions to what im doing wrong?

Any help is appriciated because I have been trying to resolve this issue for
the past 2 days.

Thanks
Nima

Email: (e-mail address removed)

 

[Clay Fox]

Hey Nima.

You can get a universal web service that you can just point at your database
and then perform dynamic queries and submits.

This is often much cheaper and easier then trying to build specific web
services for each peice of data you need and it can be reused and modified
without code by the form developer.

If you would like to learn more you can contact me here.
http://www.infopathdev.com/members/clayfox.aspx

 

[andyoye]

Clay, I went to your site and searched for "universal web service" but no
result. Can you provide more detail? I have a InfoPath 2007(web-browser
only) form hosted on my Moss 2007 site and need to submit data to a sql
server 2005 database.

Thanks

 

[Clay Fox]

It is called Database Accelerator (DBXL).

Send me an email and I can show it to you with a browser form.