Обсуждение: IODBC 3.52 with psqlODBC-08.02.0400

DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails.

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

Thanks, I built my PGSQL with ssl, after that it worked fine.

Regards,
Abhishek

-----Original Message-----
From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]
Sent: Tuesday, September 11, 2007 2:29 PM
To: Abhishek Srivastava
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] IODBC 3.52 with psqlODBC-08.02.0400

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



DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd.
Itis intended only for the use of the individual or entity to which it is addressed. If you are not the intended
recipient,you are not authorized to read, retain, copy, print, distribute or use this message. If you have received
thiscommunication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt.
Ltd.does not accept any liability for virus infected mails.