I'm having problems on a new server that has MDAC 2.7 installed on it.
I have simple code that works fine on my server that receives data back
from a SQL2000 stored proc in XML AUTO format I create a string in ASP by
looping through the result set set for rs.fields(0). But the recored set
on the new server returns mostly junk with a lot of "?" and not xml. I
don't know if it's a ADO problem or what. I have 2.6 installed on the test
server that is working fine and 2.7 on the server that isn't working.
Any thoughts on why the data is comming back messed up?
Thanks,