Re: BUG #5907: ODBC % bug

On Wed, Mar 2, 2011 at 3:06 PM, Andrew Considine
<Andrew(dot)Considine(at)sncorp(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5907
> Logged by:          Andrew Considine
> Email address:      Andrew(dot)Considine(at)sncorp(dot)com
> PostgreSQL version: 9.0.1-1
> Operating system:   Windows XP
> Description:        ODBC % bug
> Details:
>
> Using a password that contains a "%" symbol does not authenticate while
> using the ODBC driver.  The Postgresql installer accepts this password.  The
> password will even work while logging into PGAdmin.  However when connecting
> through the ODBC driver from one of our C++ applications we receive the
> following error:  FATAL: password authentication failed for user
> "<username>".  We tested this behaviour with the "%" symbol in various
> positions of the password with the same result.  Also, we tested this with
> "^" which worked as it should and "&" which also worked as it should.  It
> was only the usage of the "%" that failed to work properly while
> authenticatin via the ODBC driver.

You may want to try this question on the ODBC list, if you don't get a
response here.

http://archives.postgresql.org/pgsql-odbc/

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company