Issue Details (XML | Word | Printable)

Key: DNET-851
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Jiri Cincura
Reporter: Kjell Rilbe
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
.NET Data provider

Can't connect with mixed case user name

Created: 15/Sep/18 06:08 AM   Updated: 08/Oct/18 07:25 AM
Component/s: ADO.NET Provider
Affects Version/s: 6.3.0.0
Fix Version/s: 6.4.0.0

Environment: Firebird 3.0.3 64 bit, Windows Server 2016 64 bit, .NET Framework 4.7.1, Visual Studio 2017 Community, C# console application.


 Description  « Hide
I created a user and database in isql connected to security3.db:

create user "KorningarDev" password '***';
create database 'KorningarDev' user "KorningarDev" password '***' page_size 4096 set names 'UTF8' default character set UTF8 collation UNICODE;

I can use this database from FlameRobin, specifying the user name with quotes "KorningarDev". But I can't connect to it from the FirebirdClient. I've tried several different variations of connection string, but nothing works.

With a uppercase user, this connection string works:

Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User=DEV;Password=***

With the mixed case user name, none of these semm to work:

Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User=KorningarDev;Password=***
Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User="KorningarDev";Password=***
Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User='KorningarDev';Password=***

I would assume that the FirebirdClient, along the way, loses the quotes on the user name, causing the login request to attemt login with an uppercased username KORNINGARDEV.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Jiri Cincura made changes - 05/Oct/18 02:21 PM
Field Original Value New Value
Status Open [ 1 ] In Progress [ 3 ]
Jiri Cincura made changes - 08/Oct/18 06:38 AM
Fix Version/s 6.4.0.0 [ 10884 ]
Jiri Cincura made changes - 08/Oct/18 07:25 AM
Status In Progress [ 3 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]