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.
pgsql-odbc by date
|Next:||From: Fred Parkinson||Date: 2004-04-29 15:22:54|
|Subject: Re: Any W2K issues around odbc driver install?|
|Previous:||From: Ibrahim El-Fayoumi||Date: 2004-04-29 07:56:15|
|Subject: psqlodbc and wide characters under windows and Unix|