That seems to have done it. All my files are small < 65K (so far). So I
should be able to use this for the remainder of the scholarship application
season. I'll need to redo the website and - well the entire system needs to
be scrapped and rewritten.
Thanks so much. The students will never know who helped them get their
scholarships.
Thanks.
"Chris Lovett" <someone@nospam.please> wrote in message
news:weydnU2yhvQwojjfRVn-vQ@comcast.com...[color=blue]
> If the file is smallish you could read it all into a "string" using
> StreamReader.ReadToEnd() then do this:
>
> Dim reader as New StreamReader(fout); ' do you know the encoding? If so
> pass it to the constructor here
> Dim fixedXml = "<root>" + reader.ReadToEnd() + "</root>"
> Dim xmlRdr As New XmlTextReader(new StringReader(fixedXml))
>
> ...
>
> "Paul Nations" <pauln@adhe.arknet.nospam.edu> wrote in message
> news:%23HTpz5taFHA.1152@tk2msftngp13.phx.gbl...[color=green]
>> I'm in a real pickle. I've inherited a project with major problems. It
>> receives encrypted XML files from a website not under my control (so I
>> can't modify the web app) for insertion into a database. I'm under
>> intense pressure to get the data into the database NOW. I can decrypt
>> the files alright and they look like xml, they'll import into Access 2K3
>> with no problem, but VB.Net will not read them. It's complaining about
>> no root element, and it's right there is no root element. I've tried
>> manually adding a root to the decrypted file but the remainder winds up
>> unreadable.
>>
>> Here is the top few lines of the decrypted file.
>> <dsFullStudentDataNew xmlns="NetFrameWork">
>> <student_table>
>> <ssn>000000000</ssn>
>> <first_name>rushmi</first_name>
>> <middle_initial>p</middle_initial>
>> <last_name>john</last_name>
>> <dob>11/12/1978</dob>
>> <gender>Female</gender>
>> <present_address>16 kavanaugh</present_address>
>>
>> The code I'm using to try to read this is:
>>
>> dim sInfile as String = OpenFile(True)
>> Dim fout As FileStream = DecryptFile(sInfile)
>> Try
>> Dim xmlRdr As New XmlTextReader(fout)
>> xmlRdr.XmlResolver = Nothing
>> dsXML.ReadXml(xmlRdr) <------------error here
>> Catch e As Exception
>> Console.WriteLine(e.ToString())
>> End Try
>>
>> The error I'm getting is The root element is missing.
>>
>> But, there has to be a way tor read this file. Access 2k3 has no problem
>> with missing root element.
>>
>> What can I do to get this abomination running?
>>
>> Thanks.
>>
>>[/color]
>
>[/color]
