Re: Persisted XML files cannot be opened...

From: Val Mazur (group51a_at_hotmail.com)
Date: 02/27/04 

Date: Thu, 26 Feb 2004 22:47:17 -0500

Hi,

Code looks fine. What I would suggest to do is to run ComponentChecker
utility, which ships with MDAC to see if MDAC is not corrupted on this PC.
If yes, then you do not have choice as to fix MDAC installation. You would
need to reinstall exact same version of MDAC in this case 

-- 
Val Mazur
Microsoft MVP
"Joseph Geretz" <jgeretz@nospam.com> wrote in message 
news:ODyeva1%23DHA.3232@TK2MSFTNGP10.phx.gbl...
> Hi Val,
>
> Here's the code. (Note that I'm dealing with an XML string in memory, 
> rather
> than in an external file.) The failure occurs on the second line of code.
> The first statement plucks an ADO recordset, stored as an XML fragment, 
> from
> a larger XML document and the second statement reconstitutes it as an ADO
> recordset.
>
>       PersistedRecSet = m_XMLPackO.FacadeData("RSMail")
>       Set m_RSMail = XMLStrToRecSet(PersistedRecSet)
>
> The significant work here is done by XMLStrToRecSet which accepts a string
> parameter and returns a recordset from it. Internally, this function loads
> the string parameter into a DOM and then calls XMLToRecSet which performs
> the actual load of the recordset from the XML DOM (function listed below).
> It's all pretty standard. The error message points to a problem in the 
> MDAC
> subsystem which is outside my direct programmatic control, but I'd love to
> find a solution. My client will not be happy to re-install the OS. 
> (Although
> personally, that's exactly what I do myself as soon as a new machine comes
> out of the box. This one came from Dell with XP Pro preinstalled. I hate
> those OEM preinstallations. You never know what you're getting.)
>
> Thanks for your help,
>
> - Joe Geretz
>
> Public Function XMLToRecSet(XMLDOM As MSXML2.DOMDocument40) As
> ADODB.Recordset
>
> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
> ' Transforms an XML DOM into a recordset.                          '
> ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
>
>    Dim RS As ADODB.Recordset
>
>    On Error GoTo ErrHandle
>
>    Set RS = New ADODB.Recordset
>
>    RS.CursorLocation = adUseClient
>    RS.Open XMLDOM
>    Set RS.ActiveConnection = Nothing
>
>    Set XMLToRecSet = RS
>    Set RS = Nothing
>
>    Exit Function
>
> ErrHandle:
>
>   If Err.Source = C_LIB Then
>      Err.Raise Err.Number, C_LIB & C_CLASS & "XMLToRecSet", 
> Err.Description
>   Else
>      Err.Raise Err.Number, Err.Source, Err.Description
>   End If
>
> End Function
>
> "Val Mazur" <group51a@hotmail.com> wrote in message
> news:OP8mo60%23DHA.2212@TK2MSFTNGP10.phx.gbl...
>> Hi Joseph,
>>
>> If it is working on other PCs, then I would assume that something is
>> corrupted on your PC. Could you post code, which opens XML file?
>>
>> -- 
>> Val Mazur
>> Microsoft MVP
>>
>> "Joseph Geretz" <jgeretz@nospam.com> wrote in message
>> news:u2G4j4x%23DHA.1792@TK2MSFTNGP12.phx.gbl...
>> > I'm getting a most bizarre error and I'm at my wits end trying to
> diagnose
>> > this:
>> >
>> > Persisted XML files cannot be opened with the version of the Microsoft
> XML
>> > Parser currently installed on this computer. Upgrade your system 
>> > through
> a
>> > Windows 95/98 Service Release or Internet Explorer 5.0 or later.
>> >
>> > OK, I know where this error is emanating from. I do use XML to persist
> and
>> > de-persist recordsets in my software. The minimum supported platform is
>> > Win2K. The software is running on hundreds of workstations with no
>> > problem.
>> > What makes this error message so bizarre is that, in this case, the
>> > software
>> > is running on Win XP Pro. Yet the error message recommends a Win 95/98
>> > Service Pack upgrade. Just a bad error message?
>> >
>> > Here are the stats:
>> >
>> > WinXP Pro
>> > IE 6.0.28
>> > MDAC 2.7
>> > MSXML 4.0
>> >
>> > Has anyone seen anything like this?
>> >
>> > Thanks for your help.
>> >
>> > Joe Geretz
>> >
>> >
>> >
>>
>>
>
>

Relevant Pages

  • Re: MDAC Converting Dataset to XML
    ... I hadn't realised there was a later version of MDAC than the one we had ... recordset is fine, the code that does this is a mirror of the conversion to ... XML and for completeness I include a copy (albeit ... Can you reproduce the symptom by saving the first piece of xml to a file, ...
    (microsoft.public.data.ado)
  • Re: Persisted XML files cannot be opened...
    ... which ships with MDAC to see if MDAC is not corrupted on this PC. ... > The first statement plucks an ADO recordset, stored as an XML fragment, ... The error message points to a problem in the ...
    (microsoft.public.vb.com)
  • Re: Persisted XML files cannot be opened...
    ... which ships with MDAC to see if MDAC is not corrupted on this PC. ... > The first statement plucks an ADO recordset, stored as an XML fragment, ... The error message points to a problem in the ...
    (microsoft.public.vb.winapi)
  • Re: Persisted XML files cannot be opened...
    ... What I would suggest to do is to run ComponentChecker ... which ships with MDAC to see if MDAC is not corrupted on this PC. ... >> The first statement plucks an ADO recordset, stored as an XML fragment, ...
    (microsoft.public.vb.com)
  • Re: Persisted XML files cannot be opened...
    ... What I would suggest to do is to run ComponentChecker ... which ships with MDAC to see if MDAC is not corrupted on this PC. ... >> The first statement plucks an ADO recordset, stored as an XML fragment, ...
    (microsoft.public.data.ado)