Devart Forums

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

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

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