"Ram" <ramamohan.raj...@gmail.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs