MS SQL XML - ado 2.8 and sqlxml.... retrieve from field?

Author

ado 2.8 and sqlxml.... retrieve from field?

Dushan Bilbija

2006-01-10, 8:24 pm

hello,

i have a server side xml implementation that works great but i can't get the
data to my client.

i have a stored proc that returns 2 recordsets.... both are "selecct...
form... for xml". the data in the field is exactly as i want it (when i run
it in sql query analyzer).

problem #1: i can retrieve the text from a command object if i execute it
into an ado stream..... but i can't get both recordsets. weird, right? cause
you can get multiple recordsets from a command object.... but nope. your
command object has to write to a stream, not a recordset.

problem #2: ok, so i use a recordset. great, right? i can execute it, get my
data, move to the next recordset, get my data.... but nope. i cannot figure
out a way to get the data out of the field. it's in binary form.

i need to retrieve both text strings.... but how?

anyone help? please?

dushan bilbija

Kent Tegels

2006-01-11, 8:24 pm

Hello Dushan,

Its been years since I've worked with this and for a good reason. Using SqlXml
with classic ADO is a PITA compared to .NET. If I were you, I'd write a .NET
component that uses the ExecuteXmlReader (or even ExecuteScalar) to get the
strings and pass those back. You should be able to call that assembly (the
output of .NET compliation, given the extension DLL) from your application
as needed.

Its a hack, but it should work :)

Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

Dushan Bilbija

2006-01-12, 3:24 am

not a bad idea.... but i managed to find the solution. if you carry out a
sequence of select statements, each with for xml, the command object
retrieves them all and concatenated. so it works out well.

dushan

"Kent Tegels" <ktegels@develop.com> wrote in message
news:b87ad742a79c8c7
e4e55f74cd40@news.microsoft.com...
> Hello Dushan,
>
> Its been years since I've worked with this and for a good reason. Using
> SqlXml with classic ADO is a PITA compared to .NET. If I were you, I'd
> write a .NET component that uses the ExecuteXmlReader (or even
> ExecuteScalar) to get the strings and pass those back. You should be able
> to call that assembly (the output of .NET compliation, given the extension
> DLL) from your application as needed.
>
> Its a hack, but it should work :)
>
> Thank you,
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>
>

Sponsored Links