Help with setting up postgres and odbc

From: mike <mike(at)redtux1(dot)uklinux(dot)net>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Help with setting up postgres and odbc
Date: 2004-02-17 09:37:21
Message-ID: 1077010641.16755.26.camel@datacc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 2004-02-17 14:43:16 Re: Need new project admin for unbundled Tcl interface
Previous Message Brett Schwarz 2004-02-17 09:09:38 Re: Need new project admin for unbundled Tcl interface