70-431 Managing XML Data

sinistamunkeysinistamunkey Member Posts: 15 ■□□□□□□□□□
I am really having problems with Lessons 3 and 4 where you use the Microsoft.Data.SqlXML to perform queries on the XML data in the table.

I have run the project and even gone to the point of rewriting the project myself and once I put some error catching on it I get :

Schema: unknown SQL type 'XML' on 'Details'

Has anyone else had this problem? or is it just me being a fool icon_redface.gif

Thanks :)
Just because you can... doesn't mean you should.

Next: 70-536 and then THE WORLD!

Comments

  • LukeQuakeLukeQuake Member Posts: 579
    Hello mate! :)

    I trust that the studying is going well.

    I might be able to help you, try adding this line to your code:-

    DIV = Left + 1

    Regards,

    Luke

    (cya at work buddy)
    Microsoft Certifications: MCITP:EA, MCSE:S, MCSA:M, MCDST, MCTS: Vista Config, MCITP: Ent Support
    Citrix Certifications: CCA XenApp 4.5/5.0 and XenServer 5.0
    Other: Marathon Certified Consultant (HA, FT and VM), ISEB InfoSec Management Principles and Security+
    Working on: CISSP and Check Team Member
  • sinistamunkeysinistamunkey Member Posts: 15 ■□□□□□□□□□
    LukeQuake wrote:
    Hello mate! :)

    I trust that the studying is going well.

    I might be able to help you, try adding this line to your code:-

    DIV = Left + 1

    Regards,

    Luke

    (cya at work buddy)

    If only I had thought of using the power of a div in SQL icon_clown.gif
    Just because you can... doesn't mean you should.

    Next: 70-536 and then THE WORLD!
  • BeaverC32BeaverC32 Member Posts: 671
    Just an FYI, I believe the MSPress book goes WAY too much in depth for what you need to know for the exam.

    It is my understanding that you need to know:

    - When to use the XML datatype versus when to store XML in text format
    - Uses of the built-in XML functions such as query(), nodes(), value(), etc.
    - Indexing on XML

    Refer to either the Sybex study guide or exam cram...the MSPress book is complete overkill (not to mention very poorly explained).
    MCSE 2003, MCSA 2003, LPIC-1, MCP, MCTS: Vista Config, MCTS: SQL Server 2005, CCNA, A+, Network+, Server+, Security+, Linux+, BSCS (Information Systems)
  • fcerhafcerha Member Posts: 2 ■□□□□□□□□□
    <I might be able to help you, try adding this line to your code:>
    <DIV = Left + 1 >

    Excuse me for coming in here. I have the same problem with 2 lessons on SQLXML.
    Where do you enter this code? In VS or in the XML Document? Or even somewhere else?
    It would be very helpful if you could post a few lines of code.

    Thank's

    Fredrik
  • BeaverC32BeaverC32 Member Posts: 671
    FYI, errata for this book can be found here:
    http://support.microsoft.com/kb/920926/en-us
    MCSE 2003, MCSA 2003, LPIC-1, MCP, MCTS: Vista Config, MCTS: SQL Server 2005, CCNA, A+, Network+, Server+, Security+, Linux+, BSCS (Information Systems)
  • fcerhafcerha Member Posts: 2 ■□□□□□□□□□
    Wow, thanx a lot!
Sign In or Register to comment.