Web Services

Re: WebService SQL connection problems

dmhollis — Mon, 27 Mar 2006 17:32:45 GMT

Thanks for the post Wayne,

That got me started in the right direction. My Web method parameters were not correct...now I think I'm on the right track.

dmhollis

Re: WebService SQL connection problems

wlarimore — Wed, 22 Mar 2006 13:30:47 GMT

This is how I do it. In my web service method I provide parameters like this:

Public Function UpdateCategory(ByVal Description As String, ByVal Active As Boolean, ByVal CatID As Integer) As Boolean

There are two ways to submit via Web Service: InfoPath Data Connections Or Managed Code (Visual Studio)...

If using InfoPath Data Connections you Add your Web Service as a Submit Data Type. You map your Web Service Method parameters to the Form Template Main Data Source fields. Then you can add a button on the form and give it a Submit Action with the Data Connection you just created.

If you are using Managed Code you can do something like this in a Button Submit_OnClick event (VB.NET):

Try
Dim ws as New YourWebService.Service
ws.URL = getCurrentServiceEnvironment() 'a function
ws.Credentials = getUserCredentials() 'a function
ws.UpdateCategory(strDescription, blnActive, intCatID)
Catch ex as exception
'exception error handler here
End Try

That's it in a nutshell. If you need further examples let us know and we can point you to some better documentation than mine here in this forum.

Re: WebService SQL connection problems

dmhollis — Mon, 20 Mar 2006 13:26:13 GMT

I got past my connection error.... I included an Identity impersonate="true" tag in the web service web.config file and now it submits. However, I'm still not getting any data updated in my database. Now I seem to need some work on my dataset. Can I submit the entire form (as one of the options suggests?) I have tried submitting my fields as a group to the dataset and that isnn't working.
dmhollis

Re: WebService SQL connection problems

vt_asparagus — Thu, 16 Mar 2006 01:14:27 GMT

Is this error specific to infopath? Meaning have tried running this web service in debug mode within visual studio? Looks like you may have a connection string issue. Would you mind posting your connection string? Also ensure that you SQL Server DB allows for SQL server login accounts (Enterprise Manager >> right click DB instance >> properties >> security tab >> Authentication check "SQL Server and Windows").

WebService SQL connection problems

dmhollis — Wed, 15 Mar 2006 20:00:02 GMT

I'm having trouble submitting an Infopath form via my newly created WebService. Here's the error I keep getting when I submit:

The SOAP response indicates that an error occurred on the server:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Login failed for user 'dhollis2'.
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at InfopathService1.Service1.UpdateCustomers(DataSet dsUpdated) in c:\inetpub\wwwroot\infopathservice1\service1.asmx.cs:line 177
--- End of inner exception stack trace ---

I originally had integrated security=sspi but found a blog that told me what to do for that.... my login is the SQL db owner and has admin rights on the machine and I have made the Trusted Connection=False, but am still having no luck getting past this error. Any thoughts out there?

Thanks,

dmhollis