postgresql-odbc vs. unixODBC

From: Rainer Hochreiter <rainer(at)hochreiter(dot)at>
To: pgsql-odbc(at)postgresql(dot)org
Subject: postgresql-odbc vs. unixODBC
Date: 2005-09-27 14:27:52
Message-ID: pan.2005.09.27.14.27.52.3048@hochreiter.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

hi,

does anybody know what the differences are between postgresql-odbc
and unixODBC? because connection via postgresql-odbc work and
via unixODBC fails!

here some infos:

my /etc/odbcinst.ini:
---------------------
[PostgreSQL]
Description = ODBC for PostgreSQL (postgresql-odbc)
Driver = /usr/lib/psqlodbc.so
FileUsage = 1

[PostgreSQL2]
Description = ODBC for PostgreSQL (unixODBC)
Driver = /usr/lib/libodbcpsql.so
FileUsage = 1

my /etc/odbc.ini:
-----------------
[DB1]
Description = PostgreSQL
Driver = PostgreSQL
Database = DB1
ServerName = localhost
UserName = icp
Port = 5432

[DB2]
Description = PostgreSQL
Driver = PostgreSQL2
Database = DB2
ServerName = localhost
UserName = icp
Port = 5432

my /var/lib/pgsql/data/pg_hba.conf:
-----------------------------------
local DB1 uid md5
local DB2 uid md5

isql DB1 uid pwd => work fine
isql DB2 uid pwd => results in "[ISQL]ERROR: Could not SQLConnect"

any hints welcome!

cheers, rainer

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2005-09-27 20:11:03 Re: PostgreSQL / ODBC / Ms-SQL 2000
Previous Message Rams 2005-09-27 06:21:21 Please Send me the lastest odbc driver for vb 6.0 for postgres 8.0