Capitalization changes in UserId not recognized

Capitalization changes in UserId not recognized

Postby kww » Thu 29 Apr 2010 09:25

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
kww
 
Posts: 3
Joined: Wed 06 May 2009 08:47

Postby StanislavK » Fri 30 Apr 2010 16:08

We have reproduced the problem. We will inform you about the results of our investigation.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby StanislavK » Fri 21 May 2010 16:44

We have released the new 4.95.140 build of dotConnect for PostgreSQL. It can be downloaded from
http://www.devart.com/dotconnect/postgresql/download.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
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for PostgreSQL