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