Chris Davis wrote:
> I've been running into an issue where I get an error "password authentication failed" while using the psql ODBC driver for Windows, with the database residing on a Linux machine.
> I know my current setup is (relatively) correct since:
> 1) I've previously used a JDBC driver with postgres and md5 authentication, with no problems (with Linux on both client and server)
> 2) In Windows I can look at the ODBC sources and always verify that I can connect to the database
> 3) I'm able to fix the problem by using trust instead of md5 authentication
> Basically, I'm using the driver to connect the statistics program SPSS to a database. I can always connect to the database and see the tables, but the problem occurs when I try to make a query. The first time might work and actually return results, but after that, I consistently get the "password authentication failed" error.
Could you send me the Mylog output of the error ?
In response to
pgsql-odbc by date
|Next:||From: rahimeh khodadadi||Date: 2009-11-30 07:29:35|
|Subject: Fwd: psql+krb5|
|Previous:||From: Hiroshi Inoue||Date: 2009-11-26 11:34:16|
|Subject: Re: odbc driver leaks memory when connection failed|