Thread: jdbc connect in StarOffice

jdbc connect in StarOffice

From
Roland Gremmelspacher
Date:
Hello,
does anybody now, how it is posible not only to connect to a
postgresql-database via the jdbc-option in star-office (it works) but
how to create and display tables for example.
i think the matter is wether in the configured "code_page" or that
postgres doesnt support ANSI-SQL.

when i try to create a table (interactive with StarOffice - not in the
sql-window from starOffice) i´ll get a error message like:

parser: parser error at or near "("

the message is postet at stdout from postmaster-process and as
staroffice error-msg too.

thanx

roland

Re: [GENERAL] jdbc connect in StarOffice

From
Peter Mount
Date:
On Fri, 21 Jan 2000, Roland Gremmelspacher wrote:

> Hello,
> does anybody now, how it is posible not only to connect to a
> postgresql-database via the jdbc-option in star-office (it works) but
> how to create and display tables for example.

You've got further than I have. Out of interest, what platform are you
running StarOffice under?

> i think the matter is wether in the configured "code_page" or that
> postgres doesnt support ANSI-SQL.
>
> when i try to create a table (interactive with StarOffice - not in the
> sql-window from starOffice) i�ll get a error message like:
>
> parser: parser error at or near "("
>
> the message is postet at stdout from postmaster-process and as
> staroffice error-msg too.

I was going to try to get staroffice working with the next version, mainly
as I use it here. If you can send me how you got it working so far, I'd be
grateful, as it will help me in getting it to work.

Thanks, Peter

--
       Peter T Mount peter@retep.org.uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf