Re: SoapException SQL 0x81020024

andywt — Mon, 13 Aug 2007 21:26:22 GMT

This turned out to be another case of misdirected error messages. I found the issue, instead of using categoryCode in the Batch statement I should have used categoryID. I fixed this and all is well. Can anyone tell me why I would get a "SQL Server might not be started" error instead of something more useful?

SoapException SQL 0x81020024

andywt — Wed, 08 Aug 2007 14:21:37 GMT

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

Web Services

Re: SoapException SQL 0x81020024

SoapException SQL 0x81020024