On Mon, 24 Jun 2002 20:30:42 +0000
basis volume limited <bvol@b-vol.co.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.