Dear All,

I have made a Activex Script(VB Script) package (Local Package) in MSDE 2005. In this package I am creating XMLDOM Object. This package works perfectly well when I m executing it from (By right clicking it in) enterprise manager.

But this error " -2147023898" occurs when I m executing the same from a stored procedure. I am not able to create XMLDOM Object. Even I m not getting error description, it is only giving me error number (err.number).

Can some one please help me out.

Thanks

You have to instal the XML SDK on the server
If you run it from EM in runs on your local computer, same applies if you use Excel object etc

http://sqlservercode.blogspot.com/

Thanks for your reply.

I have the server on my local machine only. To be more specific the server and local machine as one and the same.

Thanks