FbException.ErrorCode is always returning 335544721 when try to open a connection with an invalid username/password [DNET1007]

[firebird-automations]

Submitted by: @luronumen

Attachments:
Error.png

ACTUAL RESULT
FbException.ErrorCode is always returning 335544721 when try to open a connection with an invalid username/password:

335544721
Unable to complete network request to host
No message for error code 35544721 found

EXPECTED RESULT
FbException.ErrorCode should return 33554472 error code when try to open a connection with an invalid username/password:

33554472
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

STEPS TO REPRODUCE THIS ISSUE:
- Try to open a connection to a Firebird 3.0 database with an invalid username/password.

ENVIRONMENT SETUP
==========databases.conf==========
CHRONOS_CIN = D:\APPLICATIONS\LURONUMEN\DB\CHRONOS_CIN.FDB
{
AuthServer = Srp
SecurityDatabase = CHRONOS_CIN
UserManager = Srp
}
==========firebird.conf==========
#⁠SETUP
UserManager = Srp, Legacy_UserManager
WireCrypt = Enabled
#⁠PERFORMANCE
DefaultDbCachePages = 30K
FileSystemCacheThreshold = 2M
LockHashSlots = 30011
LockMemSize = 15M
TempBlockSize = 2M
TempCacheLimit = 3000M
#⁠SECURITY
DatabaseAccess = None

Commits: aa16eb3

[firebird-automations]

Modified by: @luronumen

Attachment: Error.png [ 13531 ]

[firebird-automations]

Commented by: @mrotteveel

Error code 33554472 is not a valid Firebird error code, did you mean 335544472?

[firebird-automations]

Commented by: @luronumen

Hi Mark,

Yes I meant 335544472!
Thanks for point this!

Best Regards,
Luciano

[firebird-automations]

Commented by: @cincuranet

What's your connection string?

[firebird-automations]

Commented by: @luronumen

Hi Jiri

this is the connection string:

"pooling=True;client library=D:\\APPLICATIONS\\LURONUMEN\\GIT\\SOLUTION\\CHRONOS\\DESKTOP\\bin\\Debug\\Plugins\\FBCLIENT\\FBCLIENT.DLL;server type=Default;data http://source=CINMOTO.MOT.COM;initial catalog=CHRONOS_CIN;character set=WIN1252;role name=RDB$ADMIN;user id=CINMOTO\\wlm070;password=6543215"

[firebird-automations]

Modified by: @cincuranet

status: Open [ 1 ] => In Progress [ 3 ]

[firebird-automations]

Modified by: @cincuranet

priority: Critical [ 2 ] => Major [ 3 ]

Fix Version: vNext [ 10982 ]

[firebird-automations]

Modified by: @cincuranet

status: In Progress [ 3 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 8.0.0.0 [ 10970 ]

Fix Version: vNext [ 10982 ] =>

[firebird-automations]

Commented by: @luronumen

Retest result on version 8.0.0-alpha1: FAILED!

Hi Jiri,

Could you please confirm if this fix is available in this NuGet package: https://www.nuget.org/packages/FirebirdSql.Data.FirebirdClient/8.0.0-alpha1

Thanks in advance,
Luciano

[firebird-automations]

Commented by: @cincuranet

No it's not in alpha1.

[firebird-automations]

Commented by: @luronumen

Hi Jiri,
Now all makes sense. Please let me know when we have a new test version (alpha2?) so I can help you validate this fix.

Best regards,
Luciano

[firebird-automations]

Commented by: @cincuranet

You can test the build with this commit from https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/actions/runs/530703170.

[firebird-automations]

Commented by: @luronumen

Retest result on version 8.0.0-alpha3: PASSED!

Thank you very much for the fix Jiri!

Best Regards,
Luciano