Connect ASP.NET Core 3.1 with Interbase XE7 using FirebirdSql.Data.FirebirdClient (7.5.0) and Dapper

user_4395769 0
Viewed 299

I am trying to connect ASP.NET Core 3.1 with an Interbase XE7 database. For the connection with the Interbase database, I'm using the FirebirdSql.Data.FirebirdClient (v7.5.0) Nuget package with Dapper.

The database connection string is:

"DefaultConnectionString": "Server=localhost;Database=127.0.0.1:\\<db_name>;Uid=SYSDBA;Pwd=masterkey"

Dapper connection code :

using (var connection = new FbConnection(_config.GetConnectionString("DefaultConnectionString")))
{
    if (connection.State == ConnectionState.Closed)
    {
        connection.Open();
    }
}

Running this code results in an exception:

exception

Looking at the internet for possible solution suggests changing firebird.conf file for

WireCrypt  
AuthServer 
AuthClient

properties but I did not install Firebird on my system.

Am I in right direction or missing something?

interbase dapper asp.net-core-3.1 firebird
1 Answers

The connection rejected by remote interface means that the client and server could not agree on a protocol version while attempting to connect. Even though Firebird and Interbase have a shared history, they have diverged a lot over the past 20 years. The FirebirdSql.Data.FirebirdClient ADO.net provider does not support Interbase1. It only supports Firebird. So you cannot use it to connect to Interbase XE7.

You will need to use a driver that supports Interbase, or switch to Firebird.

1: The comments in DNET-245 and DNET-314 indicate that Interbase is not supported

user_4668620
Related