Capitalization changes in UserId not recognized

[kww]

PgSqlConnection: Changes in capitalization of UserId are only recognized if the password is changed too:

I used:

- dotConnect 4.90.124.0 TRIAL
- PostgreSQL 8.2.4
- Database encoding = UTF8

Example:

1) Does NOT work:

Devart.Data.PostgreSql.PgSqlConnection conn = new Devart.Data.PostgreSql.PgSqlConnection();
conn.Unicode = true;
conn.Host = "192.168.1.1";
conn.Port = 5432;
conn.Database = "postgres";

// First
conn.UserId = "user1";
conn.Password = "secret";

/* Do something */

// Second
conn.UserId = "User1";

conn.Open();

-> password authentication failed for user "user1"

The change of the UserId is not recognized ( although the ConnectionString recognizes)


2) DOES work:

Devart.Data.PostgreSql.PgSqlConnection conn = new Devart.Data.PostgreSql.PgSqlConnection();
conn.Unicode = true;
conn.Host = "192.168.1.1";
conn.Port = 5432;
conn.Database = "postgres";

// First
conn.UserId = "user1";
conn.Password = "secret";

/* Do something */

// Second
conn.UserId = "User1";
conn.Password = "Secret"; // THIS IS IT

conn.Open();

-> password authentication failed for user "User1"

The change of the UserId IS recognized

[StanislavK]

We have reproduced the problem. We will inform you about the results of our investigation.

[StanislavK]

We have released the new 4.95.140 build of dotConnect for PostgreSQL. It can be downloaded from
http://www.devart.com/dotconnect/postgr ... nload.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

The new build contains fix for the case-sensitivity issue on assigning the PgSqlConnection.UserId property. For more information on fixes and improvements available in version 4.95.140, please see
http://www.devart.com/forums/viewtopic.php?t=18032