-----Original Message----- From: Jeff Silberberg [mailto:jsilberberg@mindspring.com] Sent: 02 June 2003 13:12 To: dpage@postgresql.org Subject: WIN ODBC 7.03.01.0000 & MD5
Good Morning,
I need some assistance in that a number of the installed servers that we support are now using md5 as protection for the public network. This works fine, except that a few users have MS Access connections for generating adhoc reports and connect using this driver. I keep them fairly current, and in fact most are now either on 7.02.5 or the newest 7.03.01.0000.
The quick answer is to specify authentication type of 'md5' instead of 'password' in your pg_hba.conf file. The server will the ask the ODBC driver to send an MD5 digest of the password. More details are in the Administrators Guide.
PS: When in the Drivers tab of the ODBC Data Source Administrator. I have a strange entry..
PostgreSQL+(Beta) Not Marked Not Marked ...
Sounds like older versions of the driver were not uninstalled before installing the newer ones. Backup your system first in case something goes wrong, then using regedit, delete the key