IODBC 3.52 with psqlODBC-08.02.0400
am 11.09.2007 09:03:52 von abhishek_srivastava
This is a multi-part message in MIME format.
------=_NextPart_000_002B_01C7F470.03703BF0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
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. 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.
------=_NextPart_000_002B_01C7F470.03703BF0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
emas-microsoft-com:office:word" xmlns=3D"http://www.w3.org/TR/REC-html40">
..0pt;
font-family:Arial'>Hi,
..0pt;
font-family:Arial'>I have built iODBC 3.52 on Solaris and then I built psqlo=
dbc
with option --with-iodbc. When I try connecting to DB, I get the following
error:
..0pt;
font-family:Arial'>bash-3.00# ./iodbctestw "DSN=3Dpg_template1;UID=3Dx;=
PWD=3Dx"
..0pt;
font-family:Arial'>iODBC Unicode Demonstration program
nt>
..0pt;
font-family:Arial'>This program shows an interactive SQL processor
>
..0pt;
font-family:Arial'>Driver Manager: 03.52.0507.0105<=
/p>
..0pt;
font-family:Arial'>1: SQLDriverConnectW =3D [iODBC][Driver Manager]ld.so.1:
iodbctestw: fatal: relocation error: file
/export/home/psqlodbc/lib/psqlodbcw.so: symbol SSL_read: referenced symbol n=
ot
found (0) SQLSTATE=3D00000
..0pt;
font-family:Arial'>2: SQLDriverConnectW =3D [iODBC][Driver Manager]Specified=
driver
could not be loaded (0) SQLSTATE=3DIM003
..0pt;
font-family:Arial'>
..0pt;
font-family:Arial'>Any pointers to fix the problem?=
..0pt;
font-family:Arial'>
..0pt;
font-family:Arial'>Thanks,
..0pt;
font-family:Arial'>Abhishek
DISCLAIMER=0A=
===========0A=
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 inten=
ded recipient, you are not authorized to read, retain, copy, print, distribu=
te or use this message. If you have received this communication in error, pl=
ease notify the sender and delete all copies of this message. Persistent Sys=
tems Pvt. Ltd. does not accept any liability for virus infected mails.
------=_NextPart_000_002B_01C7F470.03703BF0--
Re: IODBC 3.52 with psqlODBC-08.02.0400
am 11.09.2007 10:58:41 von Hiroshi Saito
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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Re: IODBC 3.52 with psqlODBC-08.02.0400
am 11.09.2007 13:47:01 von abhishek_srivastava
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. 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.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster