psqlodbcw.so symbol lookup errors

isql works with the following errors.
stata fails to connect which I believe because of the errors.
how can I fix these errors?
Thanks !

Here is some info about the installed libraries and configuration:

installed postgresql-devel-8.1.23-1.el5_6.1.x86_64.rpm

(note if I try to ./configure --with-libpq=/usr/lib64/libpq it fails with
specified pg_config not found although it is in /usr/bin/)

installed psqlodbc-08.04.0200 from source

[toz(at)~]$ /usr/lib/libiodbc<TAB>

libiodbcinst.so.2 libiodbcinst.so.2.1.18 libiodbc.so.2
libiodbc.so.2.1.18
---------------------------------------

[toz(at)~]$ /usr/lib/libodbc<TAB>

libodbccr.so libodbcdrvcfg2S.so.1 libodbcminiS.so.1.0.0
libodbcpsql.so libodbcpsqlS.so.1.0.0

libodbccr.so.1 libodbcdrvcfg2S.so.1.0.0 libodbcmyS.so
libodbcpsql.so.1 libodbc.so

libodbccr.so.1.0.0 libodbcinst.so libodbcmyS.so.1
libodbcpsql.so.1.0.0 libodbc.so.1

libodbcdrvcfg1S.so libodbcinst.so.1 libodbcmyS.so.1.0.0
libodbcpsql.so.2 libodbc.so.1.0.0

libodbcdrvcfg1S.so.1 libodbcinst.so.1.0.0 libodbcnnS.so
libodbcpsql.so.2.0.0 libodbctxtS.so

libodbcdrvcfg1S.so.1.0.0 libodbcminiS.so libodbcnnS.so.1
libodbcpsqlS.so libodbctxtS.so.1

libodbcdrvcfg2S.so libodbcminiS.so.1 libodbcnnS.so.1.0.0
libodbcpsqlS.so.1 libodbctxtS.so.1.0.0

---------------------------------------

[toz(at)~]$ /usr/lib64/libodbc<64>

libodbccr.so libodbcdrvcfg2S.so.1 libodbcminiS.so.1.0.0
libodbcpsql.so libodbcpsqlS.so.1.0.0

libodbccr.so.1 libodbcdrvcfg2S.so.1.0.0 libodbcmyS.so
libodbcpsql.so.1 libodbc.so

libodbccr.so.1.0.0 libodbcinst.so libodbcmyS.so.1
libodbcpsql.so.1.0.0 libodbc.so.1

libodbcdrvcfg1S.so libodbcinst.so.1 libodbcmyS.so.1.0.0
libodbcpsql.so.2 libodbc.so.1.0.0

libodbcdrvcfg1S.so.1 libodbcinst.so.1.0.0 libodbcnnS.so
libodbcpsql.so.2.0.0 libodbctxtS.so

libodbcdrvcfg1S.so.1.0.0 libodbcminiS.so libodbcnnS.so.1
libodbcpsqlS.so libodbctxtS.so.1

libodbcdrvcfg2S.so libodbcminiS.so.1 libodbcnnS.so.1.0.0
libodbcpsqlS.so.1 libodbctxtS.so.1.0.0

---------------------------------------

[toz(at)~]$ cat /etc/odbc.ini

[ODBC Data Sources]

PostgreSQL = PostgreSQL

[PostgreSQL]

Description = ODBC for PostgreSQL

Driver = /usr/local/lib/psqlodbcw.so

Database = wellness

[ODBC]

InstallDir=/usr/local/lib

[Default]

Driver = /usr/lib64/libodbcpsql.so

---------------------------------------

[toz(at)~]$ cat /etc/redhat-release

Red Hat Enterprise Linux Server release 5.7 (Tikanga)

---------------------------------------

[~]$ cat .bash_profile

export ODBCSYSINI=/etc

export ODBCINI=/etc/odbc.ini

export LD_LIBRARY_PATH=/usr/local/lib

---------------------------------------

[psqlodbc-08.04.0200]$ LD_DEBUG=libs isql PostgreSQL

30006: find library=libodbc.so.1 [0]; searching

30006: search
path=/usr/local/lib/tls/x86_64:/usr/local/lib/tls:/usr/local/lib/x86_64:/usr/local/lib
(LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/tls/x86_64/libodbc.so.1

30006: trying file=/usr/local/lib/tls/libodbc.so.1

30006: trying file=/usr/local/lib/x86_64/libodbc.so.1

30006: trying file=/usr/local/lib/libodbc.so.1

30006: search cache=/etc/ld.so.cache

30006: trying file=/usr/lib64/libodbc.so.1

30006:

30006: find library=libodbcinst.so.1 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libodbcinst.so.1

30006: search cache=/etc/ld.so.cache

30006: trying file=/usr/lib64/libodbcinst.so.1

30006:

30006: find library=libdl.so.2 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libdl.so.2

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libdl.so.2

30006:

30006: find library=libpthread.so.0 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libpthread.so.0

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libpthread.so.0

30006:

30006: find library=libc.so.6 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libc.so.6

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libc.so.6

30006:

30006:

30006: prelink checking: ok

30006:

30006: calling init: /lib64/libpthread.so.0

30006:

30006:

30006: calling init: /lib64/libc.so.6

30006:

30006:

30006: calling init: /lib64/libdl.so.2

30006:

30006:

30006: calling init: /usr/lib64/libodbcinst.so.1

30006:

30006:

30006: calling init: /usr/lib64/libodbc.so.1

30006:

30006:

30006: initialize program: isql

30006:

30006:

30006: transferring control: isql

30006:

30006: find library=libnss_files.so.2 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libnss_files.so.2

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libnss_files.so.2

30006:

30006:

30006: calling init: /lib64/libnss_files.so.2

30006:

30006:

30006: calling init: /usr/lib64/gconv/ISO8859-1.so

30006:

30006: /usr/lib64/gconv/ISO8859-1.so: error: symbol lookup error:
undefined symbol: gconv_end (fatal)

30006: find library=libssl.so.6 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libssl.so.6

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libssl.so.6

30006:

30006: find library=libpq.so.4 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libpq.so.4

30006: search cache=/etc/ld.so.cache

30006: trying file=/usr/lib64/libpq.so.4

30006:

30006: find library=libgssapi_krb5.so.2 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libgssapi_krb5.so.2

30006: search cache=/etc/ld.so.cache

30006: trying file=/usr/lib64/libgssapi_krb5.so.2

30006:

30006: find library=libkrb5.so.3 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libkrb5.so.3

30006: search cache=/etc/ld.so.cache

30006: trying file=/usr/lib64/libkrb5.so.3

30006:

30006: find library=libcom_err.so.2 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libcom_err.so.2

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libcom_err.so.2

30006:

30006: find library=libk5crypto.so.3 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libk5crypto.so.3

30006: search cache=/etc/ld.so.cache

30006: trying file=/usr/lib64/libk5crypto.so.3

30006:

30006: find library=libcrypto.so.6 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libcrypto.so.6

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libcrypto.so.6

30006:

30006: find library=libz.so.1 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libz.so.1

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libz.so.1

30006:

30006: find library=libcrypt.so.1 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libcrypt.so.1

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libcrypt.so.1

30006:

30006: find library=libresolv.so.2 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libresolv.so.2

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libresolv.so.2

30006:

30006: find library=libnsl.so.1 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libnsl.so.1

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libnsl.so.1

30006:

30006: find library=libkrb5support.so.0 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libkrb5support.so.0

30006: search cache=/etc/ld.so.cache

30006: trying file=/usr/lib64/libkrb5support.so.0

30006:

30006: find library=libkeyutils.so.1 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libkeyutils.so.1

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libkeyutils.so.1

30006:

30006: find library=libselinux.so.1 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libselinux.so.1

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libselinux.so.1

30006:

30006: find library=libsepol.so.1 [0]; searching

30006: search path=/usr/local/lib (LD_LIBRARY_PATH)

30006: trying file=/usr/local/lib/libsepol.so.1

30006: search cache=/etc/ld.so.cache

30006: trying file=/lib64/libsepol.so.1

30006:

30006:

30006: calling init: /lib64/libsepol.so.1

30006:

30006:

30006: calling init: /lib64/libselinux.so.1

30006:

30006:

30006: calling init: /lib64/libkeyutils.so.1

30006:

30006:

30006: calling init: /lib64/libresolv.so.2

30006:

30006:

30006: calling init: /usr/lib64/libkrb5support.so.0

30006:

30006:

30006: calling init: /lib64/libnsl.so.1

30006:

30006:

30006: calling init: /lib64/libcrypt.so.1

30006:

30006:

30006: calling init: /lib64/libz.so.1

30006:

30006:

30006: calling init: /lib64/libcrypto.so.6

30006:

30006:

30006: calling init: /usr/lib64/libk5crypto.so.3

30006:

30006:

30006: calling init: /lib64/libcom_err.so.2

30006:

30006:

30006: calling init: /usr/lib64/libkrb5.so.3

30006:

30006:

30006: calling init: /usr/lib64/libgssapi_krb5.so.2

30006:

30006:

30006: calling init: /lib64/libssl.so.6

30006:

30006:

30006: calling init: /usr/lib64/libpq.so.4

30006:

30006:

30006: calling init: /usr/local/lib/psqlodbcw.so

30006:

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLDriverLoad (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLDriverUnload (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLAllocConnect (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLAllocEnv (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLAllocStmt (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLAllocHandleStd (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLBrowseConnectA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLColAttributeA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLColAttributes (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLColAttributesA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLColAttributesW (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLColumnPrivilegesA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLColumnsA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLConnectA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLDataSourcesA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLDescribeColA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLDriverConnectA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLDrivers (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLDriversA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLDriversW (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLError (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLErrorA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLErrorW (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLExecDirectA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLForeignKeysA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLFreeEnv (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLFreeConnect (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetConnectAttrA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetConnectOption (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetConnectOptionA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetConnectOptionW (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetCursorNameA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetDescFieldA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetDescRecA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetDescRecW (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetDiagFieldA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetInfoA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetStmtAttrA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetStmtOption (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetTypeInfoA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLNativeSqlA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLParamOptions (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLPrepareA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLPrimaryKeysA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLProcedureColumnsA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLProceduresA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLSetConnectAttrA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLSetConnectOption (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLSetConnectOptionA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLSetConnectOptionW (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLSetCursorNameA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLSetDescFieldA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLSetScrollOptions (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLSetStmtAttrA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLSetStmtOption (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLSpecialColumnsA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLStatisticsA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLTablePrivilegesA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLTablesA (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLTransact (fatal)

30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error:
undefined symbol: SQLGetDiagRecA (fatal)

+---------------------------------------+

| Connected! |

| |

| sql-statement |

| help [tablename] |

| quit |

| |

+---------------------------------------+

SQL>

-Talha