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:\\TRAXDATA.IB;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:
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?
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