Обсуждение: table_to_xml command isn't working
Hello,
I have registered an odbc entry (named xfpdb) on my Windows XP Pro machine using PosgreSQL Ansi vers. 8.02.05 (my db server is 8.3 beta 1).
Using a simple VB 6.0 code, I have tried to connect to it and return some XML information using ADO as in the following:
….
cn.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=xfpdb"
rs.Open "select * from table_to_xml('""Versions""', true, true, '')", cn
MsgBox rs.Fields(0).Value
……
The returned XML string appears truncated, as shown below:
-------------------------------------------------------------------------------------------------------
<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Version_Id>962</Version_Id>
<Version>0.0.0.0</Version>
<Process_Id>600</Process_Id>
<CreatedDateTime>2007-11-13T11:19:28.20</CreatedDateTime>
</Versions>
<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Version_Id>963</Version_Id>
<Version>0.0.0.1</Version>
<Process_Id>600</Process_Id>
<CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>
</Versions>
<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Version_Id>964</Version_Id>
<Version>0.0.0.2</Version>
<Process_Id>600</Process_Id>
<CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>
</Versions>
<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Version_Id>965</Version_Id>
<Version>0.0.0.3</Version>
<Process_Id>600</Process_Id>
<CreatedDateTime>2007-11-13T11:19:38.50</C @
-------------------------------------------------------------------------------------------------------
Same result using Labview 8.2.1 and its database connectivity tool.
But if I try to execute the query directly using pg Admin III, the XML output is correct, as shown below:
-------------------------------------------------------------------------------------------------------
<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Version_Id>962</Version_Id>
<Version>0.0.0.0</Version>
<Process_Id>600</Process_Id>
<CreatedDateTime>2007-11-13T11:19:28.20</CreatedDateTime>
</Versions>
<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Version_Id>963</Version_Id>
<Version>0.0.0.1</Version>
<Process_Id>600</Process_Id>
<CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>
</Versions>
<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Version_Id>964</Version_Id>
<Version>0.0.0.2</Version>
<Process_Id>600</Process_Id>
<CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>
</Versions>
<Versions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Version_Id>965</Version_Id>
<Version>0.0.0.3</Version>
<Process_Id>600</Process_Id>
<CreatedDateTime>2007-11-13T11:19:38.50</CreatedDateTime>
</Versions>
-------------------------------------------------------------------------------------------------------
Can anyone help me?
Thanks in advance,
Luigi
Luigi Pirillo wrote: > Hello, > > > > I have registered an odbc entry (named xfpdb) on my Windows XP Pro > machine using PosgreSQL Ansi vers. 8.02.05 (my db server is 8.3 beta 1). > > Using a simple VB 6.0 code, I have tried to connect to it and return > some XML information using ADO as in the following: Could you send me directly the Mylog output ? regards, Hiroshi Inoue
Here it is (see attached file). Regards, Luigi Pirillo -----Messaggio originale----- Da: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] Per conto di Hiroshi Inoue Inviato: mercoledì 28 novembre 2007 4.29 A: Luigi Pirillo Cc: pgsql-odbc@postgresql.org Oggetto: Re: [ODBC] table_to_xml command isn't working Luigi Pirillo wrote: > Hello, > > > > I have registered an odbc entry (named xfpdb) on my Windows XP Pro > machine using PosgreSQL Ansi vers. 8.02.05 (my db server is 8.3 beta 1). > > Using a simple VB 6.0 code, I have tried to connect to it and return > some XML information using ADO as in the following: Could you send me directly the Mylog output ? regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org