Can not select SSL mode using OpenOffice Base/Windows

Lists: pgsql-odbc
From: Felix Schwarz <felix(dot)schwarz(at)web(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Can not select SSL mode using OpenOffice Base/Windows
Date: 2009-09-19 13:30:19
Message-ID: 4AB4DCEB.5080406@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-odbc

Hi,

I'm new to this whole ODBC. I want to access a postgres db from a windows xp
client. The server only permits SSL connections (authentication is done via
passwords)...

Therefore I installed OpenOffice 3.1.1 + psqlodbc_08_04_0100. I can configure
unencrypted (non-ssl) ODBC connections using the wizard without any problems.
However in the psqlodbc setup window, the only available option for 'SSL Mode'
is disabled'. Therefore I can not connect using SSL.

The bin directory contains ssleay32.dll therefore I assume that the binaries I
have do work with SSL.

How can I get the other SSL Mode options in that wizard?
fs


From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Felix Schwarz <felix(dot)schwarz(at)web(dot)de>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Can not select SSL mode using OpenOffice Base/Windows
Date: 2009-09-20 21:32:03
Message-ID: 4AB69F53.9030005@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-odbc

Felix Schwarz wrote:
> Hi,
>
> I'm new to this whole ODBC. I want to access a postgres db from a
> windows xp client. The server only permits SSL connections
> (authentication is done via passwords)...
>
> Therefore I installed OpenOffice 3.1.1 + psqlodbc_08_04_0100. I can
> configure unencrypted (non-ssl) ODBC connections using the wizard
> without any problems. However in the psqlodbc setup window, the only
> available option for 'SSL Mode' is disabled'. Therefore I can not
> connect using SSL.
>
> The bin directory contains ssleay32.dll therefore I assume that the
> binaries I have do work with SSL.
>
> How can I get the other SSL Mode options in that wizard?

Could you please try the drivers on testing for 8.4.0101 at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue


From: Felix Schwarz <felix(dot)schwarz(at)web(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Cc: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Subject: Re: Can not select SSL mode using OpenOffice Base/Windows
Date: 2009-09-21 17:07:51
Message-ID: 4AB7B2E7.3070506@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-odbc

Hiroshi Inoue schrieb:
> Could you please try the drivers on testing for 8.4.0101 at
> http://www.geocities.jp/inocchichichi/psqlodbc/index.html
> ?

Works perfectly for me now :-)
Thank you very much.

fs

PS: The download links in the first table on your page are broken.