I am migrating my InfoPath form and code to a new Sharepoint server. Everything seems to work fine except that a routine that updates a list via web services does not. I am getting a SoapException error. I have captured the detail of the exception and the error is:
The SQL Server might not be started.
0x81020024
" String
I am confused as I am not intentionally using SQL for this application.
Any Ideas?
Here are the code snippets:
Dim listName As String
Dim listView As String
Dim errorInfoOuter As String
Dim errorInfoInner As String
Dim listsservice As New categoryList.Lists
Dim node As XmlDocument
Dim res As XmlNode
listName = "{B6FB0ADA-7507-44C7-A378-73A92B5771BE}" ' the GUID of the Sharepoint List
listView = "{DE609481-2F03-40F3-BA47-374D6631E6DE}" ' the GUID of the View of the List that is referenced
listsservice = New categoryList.Lists
listsservice.Credentials = System.Net.CredentialCache.DefaultCredentials
listsservice.Url = http://eon.intervoice.int/sites/RDboard/_vti_bin/Lists.asmx
node = New XmlDocument
node.LoadXml("" _
+ "<Batch OnError='Continue' ListVersion='1' ViewName='{DE609481-2F03-40F3-BA47-374D6631E6DE}'>" _
+ " <Method ID='1' Cmd='Update'>" _
+ " <Field Name='ID'>" + categoryCode + "</Field>" _
+ " <Field Name='LastNumUsed'>" + projectNum + "</Field>" _
+ " </Method>" _
+ "</Batch>")' call the web service
Try
res = listsservice.UpdateListItems(listName, node)
Catch e As SoapException
errorInfoOuter = e.Detail.OuterXml
errorInfoInner = e.Detail.InnerText
End Try
Dim listName As String
Dim listView As String
Dim errorInfoOuter As String
Dim errorInfoInner As String
Dim listsservice As New categoryList.Lists
Dim node As XmlDocument
Dim res As XmlNode
listName = "{B6FB0ADA-7507-44C7-A378-73A92B5771BE}" ' the GUID of the Sharepoint List
listView = "{DE609481-2F03-40F3-BA47-374D6631E6DE}" ' the GUID of the View of the List that is referenced
listsservice = New categoryList.Lists
listsservice.Credentials = System.Net.CredentialCache.DefaultCredentials
listsservice.Url = http://eon.intervoice.int/sites/RDboard/_vti_bin/Lists.asmx
node = New XmlDocument
node.LoadXml("" _
+ "<Batch OnError='Continue' ListVersion='1' ViewName='{DE609481-2F03-40F3-BA47-374D6631E6DE}'>" _
+ " <Method ID='1' Cmd='Update'>" _
+ " <Field Name='ID'>" + categoryCode + "</Field>" _
+ " <Field Name='LastNumUsed'>" + projectNum + "</Field>" _
+ " </Method>" _
+ "</Batch>")' call the web service
Try
res = listsservice.UpdateListItems(listName, node)
Catch e As SoapException
errorInfoOuter = e.Detail.OuterXml
errorInfoInner = e.Detail.InnerText
End Try
' call the web service
Try
res = listsservice.UpdateListItems(listName, node)
Catch e As SoapException
errorInfoOuter = e.Detail.OuterXml
errorInfoInner = e.Detail.InnerText
End Try