From: mike <mike@redtux1.uklinux.net>
To: pgsql-interfaces@postgresql.org
Subject: Help with setting up postgres and odbc
Date: Tue, 17 Feb 2004 09:37:21 +0000
Message-ID: <1077010641.16755.26.camel@datacc> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mike@redtux1.uklinux.net
Subject: Re: Help with setting up postgres and odbc
In-Reply-To: <1077010641.16755.26.camel@datacc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox