Can't connect with mixed case user name
---------------------------------------
Key: DNET-851
URL: http://tracker.firebirdsql.org/browse/DNET-851
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.3.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.
Reporter: Kjell Rilbe
Assignee: Jiri Cincura
Priority: Minor
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
