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