Received: from martha.trinity-bris.ac.uk (root@martha.trinity-bris.ac.uk [195.194.85.3]) by hub.org (8.8.8/8.7.5) with ESMTP id DAA28832 for ; Wed, 3 Jun 1998 03:40:27 -0400 (EDT) Received: from trinity-bris.ac.uk (hildegard.trinity-bris.ac.uk [195.194.85.10]) by martha.trinity-bris.ac.uk (8.8.0/8.8.0) with ESMTP id IAA02631 for ; Wed, 3 Jun 1998 08:40:24 +0100 Message-ID: <3574FDE7.20B5DBF0@trinity-bris.ac.uk> Date: Wed, 03 Jun 1998 08:40:23 +0100 From: Paul Roberts Organization: Trinity College Bristol X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: pgsql-interfaces@postgreSQL.org Subject: M$oft Win95, ODBC and 'crypt-ed' Passwords Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Relative newbie here .... I'm hoping to use PostgreSQL to host the busier tables on a Student Administation DBMS for three small HE colleges which we're developing at the moment. The front-end clients will be M$-Access on Win95/NT4.0 boxes. ODBC is working fine. However, I'm none-too-keen on routinely sending unencrypted passwords over the Internet link between the different sites at the moment of connection. One solution is to edit pg_hba.conf to mask host access on IP number and trust the hosts. Errm, no thanks.... The other solution which works is to send open passwords over the link - I'd rather not do this. pg_hba.conf also offers ident server authentication : I know nothing of this, but does it pertain to the M$ platform? It also offers crypt / decrypt, which UN&X/Linux could offer, but is there a M$ en-crypting solution? Have any others found a way around this problem? Is there a best solution? Regards Paul