I seem to be hitting a bit of a wall here.
This is what I have got
/etc/odbc.ini
[PostgreSQL]
Description = Datacc
Driver = PostgreSQL
Trace = Yes
TraceFile = sql.log
Database = data_cc
Servername = localhost
Host = localhost
UserName =
Password =
Port = 5432
Servertype = postgres
Protocol = 6.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
[Default]
Driver = /usr/lib/psqlodbc.so
[ODBC]
InstallDir = /usr/lib/libodbc.so
/etc/odbcinst.ini
# Example driver definitinions
#
#
# Included in the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbc.so
Setup = /usr/lib/libodbcpsqlS.so.1
FileUsage = 1
# From the MyODBC package
#[MySQL]
#Description = ODBC for MySQL
#Driver = /usr/lib/libmyodbc.so
#FileUsage = 1
using odbctest I get this when I try to connect using full connect
SQLConnect() failed
Diag(hdbc 0x82bd1b0):IM002:201:[unixODBC]Missing server name, port, or
database name in call to CC_connect.
Any help appreciated