ODBC problem

Hi

Please help... Im trying to connect to postgresql via ODBC using the
iodbc driver manager. As part of that package theres a odbctest
program that can be ran, however it appears to be failing. Im kind of
stumped as to where to go next as the error isn't too usefull.

The error I am getting in the iodbc tracefile is..

SQLDriverConnect( ... )
SQL_NO_DATA_FOUND

odbctest just exits with no usefull information..

When I run odbctest I connect to it using the connect string :
DSN=Postgres and It seems to be finding my odbc.ini file okay. My
odbc.ini file looks like

;
; odbc.ini
;
[ODBC Data Sources]
Postgres = Postgres

[Postgres]
Driver = /usr/local/pgsql/lib/libpsqlodbc.so.0
Host = localhost
Database = marksdb
TraceFile = /tmp/odbc.trace
Trace = 1

Im pretty new to this so its almost certainly an education problem. Is
there any better documentation on ODBC installation/configuration at all
for postgresql

Mark