Have you read page 472 in Chapter 11? The author goes on with the example
to say that the method is not so easy after all.
I got around this with the following code:
Calling page:
<OBJECT classid="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33" ID="dsoXYZ"
HEIGHT=0 WIDTH=0>
<PARAM NAME="URL" VALUE="Sample2.asp">
</OBJECT>
...
DataPage.asp:
<%
dim rs
dim objStream
Set objStream = Server.CreateObject("ADODB.Stream")
rs.Save objStream, adPersistXML
Response.Write objStream.ReadText
...
%>
-Joe
> Hi!
> I am not sure, if you are still looking for the answer..
> with my experience, I figured if the data getting from datapage.asp is
u> sed by another process, this page doesn't quite work functional.. I can
b> e wrong,
> but when I did it, datapage.asp accesses a com component that access db2
t> ables, if I had any of the other process using com object or main frame
s> creens, I would get the same error message, but when I close those,
this
p> age returns data and works as expected.
>
>> Many people have had the same problem, but I can't find a solution.
W> > hy does the example code not work?
> > I mean the following:
> > <OBJECT id="dsoDataBase" classid="clsid:BD96C556-65A3-11D0-983A-
0> > 0C04FC29E33">
> > <PARAM NAME="URL" VALUE="Datapage.asp">
<> > /OBJECT>
> > Datapage.asp is the same as in the book.
T> > he error I get is that the system cannnot read the database because
i> t's
c> > losed.
S> > o:
> > HOW DO I OPEN THAT #$#$##?!? DATABASE?
(> > Sorry, been trying to long).
> > With regards