Re: BUG #5907: ODBC % bug

On Wed, Mar 2, 2011 at 3:06 PM, Andrew Considine
<Andrew.Considine@sncorp.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05907
> Logged by: =A0 =A0 =A0 =A0 =A0Andrew Considine
> Email address: =A0 =A0 =A0Andrew.Considine@sncorp.com
> PostgreSQL version: 9.0.1-1
> Operating system: =A0 Windows XP
> Description: =A0 =A0 =A0 =A0ODBC % bug
> Details:
>
> Using a password that contains a "%" symbol does not authenticate while
> using the ODBC driver. =A0The Postgresql installer accepts this password.=
 =A0The
> password will even work while logging into PGAdmin. =A0However when conne=
cting
> through the ODBC driver from one of our C++ applications we receive the
> following error: =A0FATAL: password authentication failed for user
> "<username>". =A0We tested this behaviour with the "%" symbol in various
> positions of the password with the same result. =A0Also, we tested this w=
ith
> "^" which worked as it should and "&" which also worked as it should. =A0=
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/

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