The OpenSource ODBC driver doesn't support SSL. Try
http://www.commandprompt.com/ ... Mammoth S/ODBC 7.3.4 does support SSL.
CG
--- Sydney Delieu <syddel@hotmail.com> wrote:
> Hello,
>
> I installed PostgreSQL 7.4 with openssl option on SuSE 9.0. I created
> the server.crt and server.key certificates as outlined in the online
> PostgreSQL manual, and placed these certificates in the
> /usr/local/pgsql/data directory. I then changed the 'ssl = false' to
> 'ssl = true' in postgresql.conf, and also added to pg_hba.conf:
>
> hostssl TempDB testssluser 0.0.0.0 0.0.0.0 md5
>
> Trying to connect from Windows using the PG ODBC 7.03.02 driver fails.
>
> If I change my pg_hba.conf file to:
>
> host TempDB testssluser 0.0.0.0 0.0.0.0 md5
>
> then all works fine.
>
> This is the first time I've used PostgreSQL, so any help/pointers would
> really be appreciated.
>
> Regards,
> Sydney Delieu.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
