Thread: Error using pgsql-odbc with OpenOffice
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
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
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