Post reply

Problem creating large XML File

  • August 17, 2004 at 10:33 am

    #102161

    I am having a problem creating a large XML file due to the fact that ODBC can't handle more than 2030 some odd characters per line or something to that effect.  It puts line feeds at bad places splitting column names and/or words in the middle.

    I need a way to avoid this problem.  I think I have found something in the section titled

    Using ADO Command Dialect and the FOR XML Clause

    of the article found at the following link http://www.perfectxml.com/Articles/XML/ExportSQLXML.asp

    Unfortunately I don't know much about ADO, nor ASP, nor the error I get when I try to use the example given.  I get this error:

    Server object error 'ASP 0177 : 800401f3'

    Server.CreateObject Failed

    /xml.asp, line 12

    Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.

    We have installed MDAC 2.8 after getting this error and it still persists.  Can anyone help me out?  Either with this problem or if you have another solution I can use to avoid the ODBC limitation that would be great.

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • August 17, 2004 at 10:43 am

    #519396

    Sorry, in my haste to post my problems I think I failed to give enough info.  We are using SQL Server 2000 and was trying to use the FOR XML option with the sp_makewebtask to create the file.  That's when we learned of the ODBC limitation.  So I searched for alternate methods and found the one mentioned above.  The goal is to get the results of a query into an XML format.

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • August 18, 2004 at 12:32 am

    #519489

    If you're matching the sample code from the wesite you referred to, then line 12 should look something like this:

    Set objXMLDoc = Server.CreateObject("MSXML2.DOMDocument.4.0")

    The MSXML2.DOMDocument.4.0 object is part of MSXML 4, which is a separate install from MDAC.  The installation for that, plus the latest version of MSXML 3 and SQLXML, can be found by going to:

    http://msdn.microsoft.com/XML/XMLDownloads/default.aspx

    'Microsoft XML Core Services 4.0 Service Pack 2' is what you are looking for.

    HTH,

    -Eddie

    Eddie Wuerch
    MCM: SQL

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply