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@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx)


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend