Re: Posgresql - openoffice-JDBC

On Mon, 24 Jun 2002 20:30:42 +0000
basis volume limited <bvol(at)b-vol(dot)co(dot)uk> wrote:

> On Monday 24 June 2002 01:58, you wrote:
> > Once I added that to the class path, all works well! I also use
> > unixODBC with PostgreSQL & OpenOffice.
>
> did you manage to use the OO/SO dialogs (General and ODBC tabs)
> through Tools>Data Sources or did you edit the .odbc.ini file. If it
> was the former could you let me know the settings please?
>
> I compiled an ODBC driver that came with postgres and had to edit
> .odbc.ini to get it to work.

With the driver supplied with PostgreSQL I had to manually edit the
odbc.ini file. When I changed and used the driver supplied with unixODBC
the GUI worked.

When I setup my connecition with ODBCConfig, the Driver is:
/usr/lib/libodbcpsql.so
and the Setup is:
/usr/lib/libodbcpsqlS.so

According to unixODBC, they have made changes to the code, and have given
it back to PostgreSQL. I do not know when PostgreSQL will incorperate
those changes.