Problem using an ADO.DB Stream with msxml4
Posted on 2004-04-08
I have a vb com+ object that has a function that is supposed to return XML from a stored procedure.
It gets the XML via an ADO stream object.
My project references has;
MS ActiveX Data Objects 2.6 Library
MS XML v4.0
I run the VB from its test harness in the project group it gives the following error;
MSXML3: Reference to undeclared namespace prefix: 'sql'.
If I debug print the XML out it before writing it to the stream it gives ;
<ROOT xmlns:sql='urn:schemas-microsoft-com:xml-sql'><sql:header><sql:param name='ID'>
exec sp100PaAddress_Select @ID