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
Capitalization changes in UserId not recognized
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
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
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