Re: IODBC 3.52 with psqlODBC-08.02.0400

["Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>]

Hi.

Symbol reference problem in the case of without SSL,
please BUILD PostgreSQL including SSL.

inet% pg_config --libs
-lpgport -lssl -lcrypto -lz -lreadline -lcrypt -lm

inet% ldd `pwd`/psqlodbcw.so
/home/saito/PSQLODBC/psqlodbc/.libs/psqlodbcw.so:
       libpq.so.5 => /usr/local/pgsql/lib/libpq.so.5 (0x281bb000)
       libpthread.so.2 => /usr/lib/libpthread.so.2 (0x281d4000)
       libiodbc.so.3 => /usr/local/lib/libiodbc.so.3 (0x281f9000)
       libiodbcinst.so.3 => /usr/local/lib/libiodbcinst.so.3 (0x2823d000)
       libc.so.6 => /lib/libc.so.6 (0x28077000)
       libssl.so.4 => /usr/lib/libssl.so.4 (0x2824d000)
       libcrypto.so.4 => /lib/libcrypto.so.4 (0x2827b000)
       libcrypt.so.3 => /lib/libcrypt.so.3 (0x2836d000)

It may have the necessity for BUILD without SSL.
However, It fails now.....

Regards,
Hiroshi Saito

----- Original Message ----- 
From: Abhishek Srivastava

Hi,
I have built iODBC 3.52 on Solaris and then I built psqlodbc with option --with-iodbc. When 
I try connecting to DB, I get the following error:
bash-3.00# ./iodbctestw "DSN=pg_template1;UID=x;PWD=x"
iODBC Unicode Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0507.0105
1: SQLDriverConnectW = [iODBC][Driver Manager]ld.so.1: iodbctestw: fatal: relocation error: 
file /export/home/psqlodbc/lib/psqlodbcw.so: symbol SSL_read: referenced symbol not found 
(0) SQLSTATE=00000
2: SQLDriverConnectW = [iODBC][Driver Manager]Specified driver could not be loaded (0) 
SQLSTATE=IM003

Any pointers to fix the problem?

Thanks,
Abhishek