Re: For XML

Thanks - that answers one of my questions of what versions of mssql support
that. I only found any info in 2005 books on line so I didnt think it was
supported on 2000. I'll have a look.

The other thing I'm missing is currently in Icommand.execute I pass
IDBAsyncStatus or IMultipleResults. Can these still be used when you need
to endup with ISequentialStream? Initial tests say no but it was a quick
test and I havent finished all the possible combinations.

Jim Kane

"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns97FF47586C88Yazorman@xxxxxxxxxxxx
jim kane (jkane@xxxxxxxxxxx) writes:
Using Oledb Interfaces directly ( not ado or .net drivers ), how do I get
the xml result of a select statement that uses For XML AUTO.

At http://go.microsoft.com/fwlink/?LinkID=4172 there is a set of
samples for OLE DB and ODBC programming. I believe there is a sample
for retrieving XML data.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


.

Relevant Pages

  • Re: For XML
    ... support that. ... I only found any info in 2005 books on line so I didnt ... To get results for FOR XML, I believe you have to use ISequentialStream. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.data.oledb)
  • Re: More about 70-228?
    ... >> How do you rate the help included with SQL Server the SQL Server Books ... there is some XML on one of the two exams as ... I don't remember any questions on XML in the 228 exam (even though it ...
    (microsoft.public.cert.exam.mcse)
  • Re: MS Access Reports and VB.NET Program
    ... think that I want to ship a 30mb .NET framework to each of my clients? ... Barns & Noble has some books that could help you learn .NET. ... It is Access TIMES eCommerce TIMES Sql Server. ... that you actually posted how to execute the report using a macro. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Getting started in IT.
    ... Have ordered both books. ... MCITP SQL Server 2005 Database Administration All-in-One Exam Guide ...
    (microsoft.public.cert.mcdba)
  • Re: Requirements to Run ADO.NET Application
    ... Okay, AFA SQLCe, consider that the functionality you get for that 1MB database engine might be just what you need. ... Hitchhiker's Guide to Visual Studio and SQL Server ... I'm working through a stack of books that involves many technologies and SQL is just one of them. ...
    (microsoft.public.dotnet.framework.adonet)