COMException--Why?
-
While using MemoryStream in the context of SQLXML3.0 sxcmd.commandText="Name of stored proc on database"
sxcmd.RootTag = "FullName" Line 36: Dim MemSt As MemoryStream Line 37: MemSt = sxcmd.ExecuteStream()---->Problem on this line Line 38: Response.Write(MemSt.Length) Line 39: Dim strRdr As New StreamReader(MemSt)System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80040E21. -
While using MemoryStream in the context of SQLXML3.0 sxcmd.commandText="Name of stored proc on database"
sxcmd.RootTag = "FullName" Line 36: Dim MemSt As MemoryStream Line 37: MemSt = sxcmd.ExecuteStream()---->Problem on this line Line 38: Response.Write(MemSt.Length) Line 39: Dim strRdr As New StreamReader(MemSt)System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80040E21.If you know your SQL Syntax is good, then you should check permissions. You might consider trying to run it with SA priviledges on the database to see if it works. If so, you know where your problem is. Also if you are using XML AUTO in your query try XML RAW and see if it goes away. Otherwise I'm not sure. But that's where I'd start trying to troubleshoot. Torin Blair
'In the immortal words of Socrates - "I drank what?".' -
If you know your SQL Syntax is good, then you should check permissions. You might consider trying to run it with SA priviledges on the database to see if it works. If so, you know where your problem is. Also if you are using XML AUTO in your query try XML RAW and see if it goes away. Otherwise I'm not sure. But that's where I'd start trying to troubleshoot. Torin Blair
'In the immortal words of Socrates - "I drank what?".'