如何使用stream对象

[Andy]

如下所示：
......
Set stmLog = Server.CreateObject ("ADODB.Stream")
Set rsLog = Server.CreateObject ("ADODB.RecordSet")
......... 取得纪录集rsLog
rsLog.Save stmLog,1
Dim strLog

strLog = stmLog.ReadText

Response.Write strLog
在stmLog.ReadText 会出错，原因是stmLog对象未打开，但是如何打开这个对象呢

[karma]

do not know what you did, but this code works for me (w2k server/iis5, sql server 2000)

<%
Response.ContentType="text/xml"
strConn = "Provider=SQLOLEDB;Server=localhost;Database=pubs;UID=sa;PWD=;"
set rs = Server.CreateObject("ADODB.Recordset")
set st = Server.CreateObject("ADODB.Stream")
rs.Open "Select * from authors", strConn
rs.Save st,1
Response.Write st.ReadText
rs.Close
set rs=nothing
set st=nothing
%>