Re: Error using pgsql-odbc with OpenOffice

Matthew Hagerty wrote:
> Greetings,
>
> I'm not sure which component is responsible for this error, but I needed
> to start somewhere...
>
> Versions I'm using:
>
> Windows XP sp2
> OpenOffice 2.2.0
> PG 8.2.3 (running on FreeBSD 6.2)
> pgODBC 08.02.0200
>
> I've set up a System DSN for my pg database and created a new database
> with OO, selecting the "connect to an existing database" and selecting
> the DSN I set up. It prompts me for a un and pw and connects without
> problems. I can see the list of tables and even create a new table, but
> when I try to double-click a table to open it for reading or updating, I
> get this error in a dialog:
>
> ---
> The data content could not be loaded.
>
> ERROR: invalid input syntax for type tid: "(,)";
> Error while executing the query

Could you try the snapshot driver at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html ?

regards,
Hiroshi Inoue

> [OK] [More]
> ---
>
> Clicking "More" gives this additional information:
>
> SQL Status: 22P02
> Error code: 7
>
> I tried logging the connection with the driver but did not see the
> offending query in the logs. A Google search turned up very little
> other than someone asking about this back in 2004 with little or no
> resolution. Any insight would be greatly appreciated.
>
> Thanks,
> Matthew