From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Ram" <ramamohan(dot)raju31(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6287: Unexpected protocol character during authentication |
Date: | 2011-11-04 22:37:03 |
Message-ID: | 18033.1320446223@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
"Ram" <ramamohan(dot)raju31(at)gmail(dot)com> writes:
> My odbc.ini is like below:
> ---------------------------
> [FH1SQL1]
> Description = PostgreSQL connection to 'dbProjNum' database
> Driver = /usr/lib64/libodbcpsql.so.2.0.0
> Setup = /usr/lib64/libodbcpsqlS.so.1.0.0
You're apparently using the very obsolete and buggy Postgres ODBC driver
that ships with unixODBC --- or at least used to ship with unixOBC; I
think they ripped it out in the most recent release. Get hold of the
postgresql-odbc package (that's what Red Hat calls it, at least, dunno
about whatever distribution you're using) and use the driver from that
instead.
I usually recommend this configuration for the driver definition:
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbc.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbc.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
Depending on which build of postgresql-odbc you're using, the driver
library file might be named psqlodbcw.so instead; but in any case
libodbcpsql.so is not something to trust.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2011-11-05 03:44:30 | Re: BUG #6281: need to remove |
Previous Message | John R Pierce | 2011-11-04 21:57:09 | Re: BUG #6281: need to remove |