IODBC 3.52 with psqlODBC-08.02.0400

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

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sch=
emas-microsoft-com:office:word" xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hi,<o:p></o:p>

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:<o:p></o:p>

bash-3.00# ./iodbctestw "DSN=3Dpg_template1;UID=3Dx;=
PWD=3Dx"
<o:p></o:p>

iODBC Unicode Demonstration program<o:p></o:p></fo=
nt>

This program shows an interactive SQL processor<o:p></o:p=
>

Driver Manager: 03.52.0507.0105<o:p></o:p><=
/p>

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<o:p></o:p>

2: SQLDriverConnectW =3D [iODBC][Driver Manager]Specified=
driver
could not be loaded (0) SQLSTATE=3DIM003<o:p></o:p>

<o:p> </o:p>

Any pointers to fix the problem?<o:p></o:p>=


<o:p> </o:p>

Thanks,<o:p></o:p>

Abhishek<o:p></o:p>

</div>

DISCLAIMER=0A=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=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.
</body>

</html>

------=_NextPart_000_002B_01C7F470.03703BF0--

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

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

Regards,
Abhishek

-----Original Message-----
From: Hiroshi Saito [mailto:z-saito [at] guitar.ocn.ne.jp]
Sent: Tuesday, September 11, 2007 2:29 PM
To: Abhishek Srivastava
Cc: pgsql-odbc [at] 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

IODBC 3.52 with psqlODBC-08.02.0400

Re: IODBC 3.52 with psqlODBC-08.02.0400

Re: IODBC 3.52 with psqlODBC-08.02.0400