Thread: BUG #5907: ODBC % bug

BUG #5907: ODBC % bug

From
"Andrew Considine"
Date:
The following bug has been logged online:

Bug reference:      5907
Logged by:          Andrew Considine
Email address:      Andrew.Considine@sncorp.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.

Re: BUG #5907: ODBC % bug

From
Robert Haas
Date:
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