Skip site navigation (1) Skip section navigation (2)

md5 authentication issues with psqlODBC driver for Windows

From: Chris Davis <c_b_dvs(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: md5 authentication issues with psqlODBC driver for Windows
Date: 2009-11-24 20:40:29
Message-ID: 174325.97827.qm@web112010.mail.gq1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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.  

Is there a chance this is a bug/human error with how I'm using the driver, or should I be on the SPSS message forum instead?

Thanks,

Chris



      

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2009-11-26 11:34:16
Subject: Re: odbc driver leaks memory when connection failed
Previous:From: Josh TDate: 2009-11-24 12:47:44
Subject: Re: VBA ADO Command Date Parameter Not Working

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group