unixODBC + PostgreSQL 6.5.1 - Mailing list pgsql-interfaces

Hello,

I tried to use unixODBC to connect to a PostgreSQL 6.5.1 DB via
StarOffice. I couldn't successfully configure odbcinst.ini or
odbc.ini. I started isql which failed with the following message:

[jd9@jan jd9]$ isql template1
[ISQL]ERROR: Could not SQLConnect

There are two obscure entries in the logfile:

[ODBC][22911][SQLConnect.c][1378]
                Exit:[SQL_ERROR]
[ODBC][22911][SQLFreeHandle.c][174]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x804c5d8

I used the attached .ini files.

Can someone help?

Jan
--
  \___________________________________________________________
Jan Dittberner
Technical University Dresden - department of computer science
--------------------------------------------------------------
mail: jan@jan-dittberner.de
==============================================================[PSQL-Test]
Description        = PostgreSQL für DB 'jd9' auf localhost
Driver            = Postgresql
Trace            = Yes
Tracefile        = /tmp/postgresql_proto
Database        = jd9
Host            = localhost
Username        =
Password        =
Port            = 5432
Protocol        = 6.5
ReadOnly        = No
RowVersioning    = No
ShowSystemTables= No
ShowOidColumn    = No
FakeOidIndex    = No
ConnSettings    =

[template1]
Description        = template1
Driver            = postgresql
Trace            = Yes
Tracefile        = /tmp/postgresql.log
Database        = template1
Host            = localhost
Username        =
Password        =
Port            = 5432
Protocol        = 6.4
ReadOnly        = No
RowVersioning        = No
ShowSystemTables    = No
ShowOidColumn        = No
FakeOidIndex        = No
ConnSettings        =
[Postgresql]
Description    = PGSQL 6.5.1
Driver        = /usr/local/lib/libodbcpsql.so.1.0.0
Setup        = /usr/local/lib/libodbcpsqlS.so.1.0.0
FileUsage    = 1
Debug        = 0