[unixODBC-support] Trouble connecting with PostgreSQL driver

Nick Gorham nick at lurcher.org
Wed Jan 14 21:30:39 GMT 2015

On 14/01/15 20:04, Julie Reier wrote:
> $ ldd /usr/lib64/libodbcpsql.so
> linux-gate.so.1 =>  (0x0035b000)
> libnsl.so.1 => /lib/libnsl.so.1 (0x00c28000)
> libdl.so.2 => /lib/libdl.so.2 (0x00759000)
> libcrypt.so.1 => /lib/libcrypt.so.1 (0x00a7f000)
> libm.so.6 => /lib/libm.so.6 (0x00e61000)
> libpthread.so.0 => /lib/libpthread.so.0 (0x00eff000)
> libc.so.6 => /lib/libc.so.6 (0x003b7000)
> /lib/ld-linux.so.2 (0x00101000)
> libfreebl3.so => /lib/libfreebl3.so (0x00cdd000)

That all looks fine.

Given the driver is not using libodbc.so to read the ini file, try setting

export ODBCINI=/usr/local/unixODBC/etc/odbc.ini

so the driver can find the ini file.

Failing that try using

     strace -o st.log isql -v rndredshift readonly ********

To see if it shows any failed attempt to read a lib or other file.


More information about the unixODBC-support mailing list