Incompatible wire encryption levels requested on client and server with Firebird ado.net provider

c# firebird firebird-3.0 firebird-.net-provider
Marcoscdoni picture Marcoscdoni · May 28, 2016 · Viewed 15k times · Source

I am testing the connection firebird 3 using C #. The version of what I'm used is the latest : Firebird ADO.NET Provider 5.0. But when you make the connection , the error occurs "Incompatible wire encryption levels requested on client and server"."

At "Does Firebird ADO.NET 4.10.0.0 Data provider work with Firebird 3.0?", there are some suggestions for enabling authentication in legacy model or create legacy user.

But my question is if really does not support to new SRP authentication model in version 5.0 Net Provider?

Answer

Mark Rotteveel picture Mark Rotteveel · May 28, 2016

The problem has nothing to do with SRP in itself, but that the Firebird .NET provider version 5.0.0.0 only added SRP support, but does not yet implement the wire protocol encryption. This wire protocol encryption does - by default - depend on SRP for its session key, but the fact SRP is implemented, does not imply that wire protocol encryption is implemented.

Firebird 3 by default requires encryption, but as this is not supported in Firebird .NET provider version 6 and earlier, you get the error "Incompatible wire encryption levels requested on client and server".

To be able to use wire encryption, you need to update to Firebird ADO.net provider version 7. Version 7 added support for wire encryption, see ADO.NET provider 7.0.0.0 for Firebird is ready for more information.

Or, alternatively, you need to configure Firebird 3 to enable but not require encryption by editing firebird.conf:

WireCrypt = Enabled

And then restarting Firebird.

Related questions

C# constructing parameter query SQL - LIKE %

I am trying to build SQL for a parameter query in C# for a query which will contain the LIKE %% command. Here is what I am trying to acheive (please note that the database is Firebird) var SQL = string.format("…

Read More
How to connect and use Firebird db embedded server with Visual C# 2010

I was trying to use Firebird embedded server with Microsoft Visual C# 2010. so here is what I done till now: Downloaded Firebird .Net Data Provider (Firebird Client v2.5.2). Downloaded Firebird Embedded server (Firebird Embedded Server v2.5.0). Added a reference to …

Read More
Entity Framework Code First - Cast smallint and integer to int32

Im working on a small service tool for a database. My problem is that due the last update, some smallint-colums had to be be changed into integer. public class TEST { public int ID { get; set; } //public Int16 ID { get; set; } …

Read More