asp file read binary data in sql server 2000

[izumi]

I write the code as follows.....

But I cannot print the binary data as meaningful data format.

any idea????????
Response.Buffer = True
Const adTypeBinary = 1
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Type = adTypeBinary

response.binarywrite rs("abc")

[Manohar Kamath [MVP]]

You need to tell the browser the MIME type of incoming stream. Perhaps
something like

Response.ContentType = "application/msword"

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"izumi" <te**@test.com> wrote in message
news:eg**************@TK2MSFTNGP09.phx.gbl...

I write the code as follows.....

But I cannot print the binary data as meaningful data format.

any idea????????
Response.Buffer = True
Const adTypeBinary = 1
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Type = adTypeBinary

response.binarywrite rs("abc")

[izumi]

Sorry it doesnot work
Response.ContentType = "text/HTML"
"Manohar Kamath [MVP]" <mk*****@TAKETHISOUTkamath.com> wrote in message
news:OJ*************@TK2MSFTNGP11.phx.gbl...

You need to tell the browser the MIME type of incoming stream. Perhaps
something like

Response.ContentType = "application/msword"

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"izumi" <te**@test.com> wrote in message
news:eg**************@TK2MSFTNGP09.phx.gbl...

I write the code as follows.....

But I cannot print the binary data as meaningful data format.

any idea????????
Response.Buffer = True
Const adTypeBinary = 1
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Type = adTypeBinary

response.binarywrite rs("abc")