how to read xml file using vb6?

how to read xml file using vb6?

Post by lvqi » Sun, 15 Oct 2000 04:00:00



hi,
    I know little about XML .Now I want to read a XML file about Orders
using vb6,then i will put it into a table in Oracle8i. How should i do?
                                                            jacky

 
 
 

how to read xml file using vb6?

Post by William Highfiel » Sun, 15 Oct 2000 04:00:00



and posted to microsoft.public.vb.database:

>hi,
>    I know little about XML .Now I want to read a XML file about Orders
>using vb6,then i will put it into a table in Oracle8i. How should i do?
>                                                            jacky


Do some more reading on the XML Parser from MS.

http://msdn.microsoft.com/xml/default.asp

 
 
 

1. Read Multi Table XML Using ADO in VB6

Hello,
I was able to read a XML file with one table with no
problems.  But now this same xml file must now hold 2
tables and the code(below) that I'm using cannot read the
xml properly anymore.  I can also have the xsl file, I
just don't know when to use it or do i need it?  Here's my
code.  

    Dim objFundAccess As New MSSOAPLib.SoapClient
    Dim sch As String
    Dim rs As New ADODB.Recordset
    Dim fs
    Dim a

objFundAccess.mssoapinit "http://toritd204277/SSCsecuritywe
bservices/SSCSecurityWebServices.asmx?
WSDL", "SSCSecurityWebService", "SSCSecurityWebServiceSoap"

    'Debug.Print objFundAccess.FundAccess(sch)  'this
prints the xml

    'Debug.Print sch  'this prints the schema

    Set fs = CreateObject("Scripting.FileSystemObject")
    Set a = fs.CreateTextFile("c:\tmpFundAccess.xml", True)
    a.WriteLine (objFundAccess.FundAccess(sch))
    a.Close

    ' Set up the Connection
    rs.ActiveConnection = "Provider=MSDAOSP; Data
Source=MSXML2.DSOControl.2.6;"

    ' Open the XML source
    rs.Open "C:\tmpFundAccess.xml"

    Do Until rs.EOF
        Debug.Print rs.Fields(2)
'The line above should print the value on the third
field, 'instead it's printing all the records from the xml
file.
        rs.MoveNext
    Loop

Please help me,
Joseph

2. INFORMIX/INGRES

3. Reading in different file formats using vb6

4. Query/SQL VBX?

5. Reading from *.xls files into Access 97 Using VB6

6. Data source name not found and no default driver specified

7. Reading from XML-file using ADO und Visual C++

8. PICK For Linux

9. Error 3027 (object = read-only) when using VB6 to open read/write recordset on SQL 7.0

10. Parsing XML files in VB6

11. How to assimilate a dbase file using file opens() and reads()

12. how to read record in VB6.0 and then write it to file