automation server can't create object adodb stream

[Kevin Shea]

We get the following error:

"Automation server can't create object"

for some of our Windows clients (XP and 2000), at the following line of
Javascript code:

stream = new ActiveXObject("adodb.stream");

This error just started occurring. Any thoughts?

[Bob Barrows [MVP]]

Post by Kevin Shea
"Automation server can't create object"
for some of our Windows clients (XP and 2000), at the following line
stream = new ActiveXObject("adodb.stream");
This error just started occurring. Any thoughts?

http://support.microsoft.com/default.aspx?scid=kb;en-us;870669

Bob Barrows

[Kevin Shea]

Thanks Bob, that's exactly the issue.

Here's a second question:

I am essentially using the stream object to convert XML into an ADO
recordset. Is there another way to do this without the stream object?

Here is my code:

stream = new ActiveXObject("adodb.stream");
stream.Open;
stream.WriteText(strXML);
stream.Position = 0;
rs = new ActiveXObject("adodb.recordset");
rs.Open(stream);
stream.Close;
stream = null;

Post by Bob Barrows [MVP]

Post by Kevin Shea
"Automation server can't create object"
for some of our Windows clients (XP and 2000), at the following line
stream = new ActiveXObject("adodb.stream");
This error just started occurring. Any thoughts?

http://support.microsoft.com/default.aspx?scid=kb;en-us;870669
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

...

[Bob Barrows [MVP]]

No, I'm pretty sure the Stream is required, whether it's explicitly created
or implicitly. Just to be sure, you can try:

xmldoc = new ActiveXObject("msxml2.domdocument")
xmldoc.loadXML(strXML)
rs.Open(xmldoc)

I'm pretty sure an implicit Stream object is used here, but I may be wrong.

Bob Barrows

Post by Kevin Shea
Thanks Bob, that's exactly the issue.
I am essentially using the stream object to convert XML into an ADO
recordset. Is there another way to do this without the stream object?
stream = new ActiveXObject("adodb.stream");
stream.Open;
stream.WriteText(strXML);
stream.Position = 0;
rs = new ActiveXObject("adodb.recordset");
rs.Open(stream);
stream.Close;
stream = null;

Post by Bob Barrows [MVP]

Post by Kevin Shea
"Automation server can't create object"
for some of our Windows clients (XP and 2000), at the following line
stream = new ActiveXObject("adodb.stream");
This error just started occurring. Any thoughts?

http://support.microsoft.com/default.aspx?scid=kb;en-us;870669

...

[kewlgeek]

Actually, you can. This article from Microsoft tells you how:

http://tinyurl.com/g6nch



--
kewlgeek
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------