Error using pgsql-odbc with OpenOffice
Error using pgsql-odbc with OpenOffice
От:
Matthew Hagerty <matthew@digitalstratum.com>
Дата:
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 [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
Re: Error using pgsql-odbc with OpenOffice
От:
Hiroshi Inoue <inoue@tpf.co.jp>
Дата:
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
Re: Error using pgsql-odbc with OpenOffice
От:
Matthew Hagerty <matthew@digitalstratum.com>
Дата:
Hiroshi Inoue wrote: > 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 > Okay, that took care of the "(,)" error, now I'm getting this: --- SQL Status: 42703 Error code: 7 ERROR: column "oid" does not exist; Error while executing the query --- Does not matter if the table exists or if I create a new table (which does work). Thanks, Matthew
