Help with setting up postgres and odbc - Mailing list pgsql-interfaces

From mike
Subject Help with setting up postgres and odbc
Date
Msg-id 1077010641.16755.26.camel@datacc
Whole thread Raw
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: Brett Schwarz
Date:
Subject: Re: Need new project admin for unbundled Tcl interface
Next
From: Bruce Momjian
Date:
Subject: Re: Need new project admin for unbundled Tcl interface