Thread: ODBC password crypting support

ODBC password crypting support

From
sulik_pbem@netmail.kg
Date:
 When trying to connect to the postgreSQL database through ODBC, I get an error
"Unknown username or password. Password crypt authentication not supported.
(errcode 13095)"
 I can assume ODBC do not support password crypting. Does that mean I cannot
connect through ODBC, or there's another way?
--- Get your private e-mail at http://www.netmail.kg

Re: ODBC password crypting support

From
Bruce Momjian
Date:
>  When trying to connect to the postgreSQL database through ODBC, I get an error
> "Unknown username or password. Password crypt authentication not supported.
> (errcode 13095)"
>  I can assume ODBC do not support password crypting. Does that mean I cannot
> connect through ODBC, or there's another way?

You can use plain password with ODBC, just not crypt password.  The
password will flow unencrypted over the network.   7.2beta3 supports MD5
encrypted passwords.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026