Thread: how to make postgresql+odbc+staroffice work? II

how to make postgresql+odbc+staroffice work? II

From
Eldad Midan
Date:
Staroffice 5.1a does not support ODBC out of the box, and I installed
PostgreSQL with ODBC driver, but I have not found anything in the docs
about ODBC.

I tried another avenue, by downloading, compiling and installing
unixODBC-1.8.1 from www.genix.net, were ODBC is central to the entire
program, and StarOffice is briefly discussed, but I did not have any
success following the instructions; they are too brief.

So, MY QUESTIONS ARE:
* how do you make postgresql use ODBC?
* how do you compel StarOffice to use the ODBC drivers
* how do you make StarOffice act as a front-end to PostgreSQL
* same questions when using the unixODBC package
* when I use the GUI to set up unixODBC, I get various error messages
telling me that the drivers I registered are not valid or that the info
in odbc.ini or odbcinst.ini doesn't make sense. Since the
administrator's guide to the package is not yet written, can anyone send
me a short set of instructions on creating an odbc database using the
unixODBC for the ODBC including drivers (I compiled the PostgreSQL
drivers) and with PostgreSQL as the server?

Please email me with your suggestions

Thank you

Re: how to make postgresql+odbc+staroffice work? II

From
"Mike DeFehr"
Date:
don't know anything about Staroffice, but ODBC is pretty much 100% on the
client - you have to find ODBC drivers that run on your client that access
PostgreSQL that Staroffice can make use of

to put it another way, PostgreSQL does not need to be compelled to use
ODBC - its up to your ODBC driver to use PostgreSQL, then its up to your
Client database software to make use of your ODBC driver

sorry I can't be of more help...


Eldad Midan wrote in message <3871884B.B359DDDA@stern.nyu.edu>...
>Staroffice 5.1a does not support ODBC out of the box, and I installed
>PostgreSQL with ODBC driver, but I have not found anything in the docs
>about ODBC.
>
>I tried another avenue, by downloading, compiling and installing
>unixODBC-1.8.1 from www.genix.net, were ODBC is central to the entire
>program, and StarOffice is briefly discussed, but I did not have any
>success following the instructions; they are too brief.
>
>So, MY QUESTIONS ARE:
>* how do you make postgresql use ODBC?
>* how do you compel StarOffice to use the ODBC drivers
>* how do you make StarOffice act as a front-end to PostgreSQL
>* same questions when using the unixODBC package
>* when I use the GUI to set up unixODBC, I get various error messages
>telling me that the drivers I registered are not valid or that the info
>in odbc.ini or odbcinst.ini doesn't make sense. Since the
>administrator's guide to the package is not yet written, can anyone send
>me a short set of instructions on creating an odbc database using the
>unixODBC for the ODBC including drivers (I compiled the PostgreSQL
>drivers) and with PostgreSQL as the server?
>
>Please email me with your suggestions
>
>Thank you