From: | "Luigi Pirillo" <luigi(dot)pirillo(at)sky-team(dot)it> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | table_to_xml command isn't working |
Date: | 2007-11-27 15:51:54 |
Message-ID: | 20071127154814.1D3562E0033@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2007-11-28 03:28:59 | Re: table_to_xml command isn't working |
Previous Message | claudia.amorim | 2007-11-27 12:09:25 | "Invalid Pointer Operation" while reading tuples |