Sorry for the cross post, but I'm stumped.
I'm trying to render the XML content that is stored as an image datatype in
the SQL Server Reporting Services database.Table Catalog, Content Colmn,
using ASP.NET (VB.NET).
These look to tbe the RDL files that get uploaded where the TYPE column = 2
in the Catalog Table.
What happens is, the xml gets rendered in IE (6.0) but is truncated at the
end because it is not well-formed. It seems most of the XML is rendered
except for a the last few lines.
Here is the error in the browser:
?//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Cannot view XML input using XSL style sheet. Please correct the error and
then click the Refresh button, or try again later.
------------------------------------------------------------------------------
Cannot have a DOCTYPE declaration outside of a prolog. Error processing
resource 'http://sauronan.gefa.a d.ga.gov/FSTProject...
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
----------^/DIV>
<PaddingTop>2pt </PaddingTop>
?/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Here's my code-behind:
Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click
Dim ImgStream As MemoryStream = New MemoryStream
Dim cn As SqlConnection = New
SqlConnection(" server=SAURONAN ;database=Repor tServer;user
id=FSTApp;passw ord='pass")
Dim rdr As SqlDataReader
Dim xName As String = ddlNme.Selected Value
Dim cmd As New SqlCommand("Get BinaryData", cn)
cmd.CommandType = CommandType.Sto redProcedure
Dim param As SqlParameter
param = cmd.Parameters. Add(New SqlParameter("@ sName", xName))
param.Direction = ParameterDirect ion.Input
cn.Open()
Dim blob() As Byte = CType(cmd.Execu teScalar(), Byte())
context.Respons e.ContentType = "text/xml"
context.Respons e.OutputStream. Write(blob, 0, blob.Length)
cn.Close()
Response.Flush( )
End Sub
Any ideas on how to get this data. I really don't care how, as long as I
have access to it.
-Troy
