Re: ODBC 7.03.02 on Windows connecting to PostgreSQL 7.4 using SSL

Hi Chris,

Thanks for the info, I will give Command Prompt Inc. a try.

Regards,
Sydney Delieu.


Chris Gamache wrote:

>
> 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
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 2: you can get off all
> lists at once with the unregister command     (send "unregister
> YourEmailAddressHere" to majordomo@postgresql.org)