FirebirdSql.Data.FirebirdClient | Firebird ADO.NET Data Provider | Object-Relational Mapping library

I had to switch my code from being in .NET Core to .NET Framework and now I get an error. the error says that local variable named 'listadb' cannot be declared in this scope. This function worked before and I don't know how to get around it now. Here is the code:

I have this program, that I have to handle the exceptions for, but I never done it so I'm kind of confused. I'm guessing I'd have to handle exceptions like the value in the textfile is empty, there is no index, there is no "=" or the file is empty, but I don't really know how to define them or where to put them. Here is my code: (the lines in the text file should look like this: EMPIS_MAG_BUDOW=12

EMPIS_DESKA_FASOLKA=2

SM_PORTAL_POL1=-4 )

I have to make a select statement on a database and than compare the results with a text file using only C# in Visual Studio. If the text file has a bigger value than the record in the database, the program returns the value from the text file, and if the database record has a bigger value, the program returns the value from the database. The results are added to a list being a class WynikPorownania{}. The user types in the file an index of a product and the value(in this case the value is it's availability condition).

For example:

The textfile says this:

WYR_WR_CZ1=12

VIDIS_JIMU_BOX=3

REREK_KOTEK_T=5

In the database, theses indexes are connected to an availability condition like this

WYR_WR_CZ1=-1.0000

VIDIS_JIMU_BOX=-13.0000

REREK_KOTEK_T=0.0000

Now the program should return the bigger value in a list being the WynikPorownania{} class.

For now, I managed to do this much: I took every record from the select query and put it in to a list as a class. I have a function that checks the "standysp"(availability condition) for a specified index, and I asigned the text file value to a string. I think that it could be done maybe with this "zwr" function and maybe a loop but I don't really know where to go from now on. This is my code for now:

I recently downloaded the new Firebird 4 server and installed it. It's running as a service on my Windows 10 box. I'm able to connect to it just fine with the FB Maestro IDE, but when I try to connect to it from some ADO.NET code, I get an error. Upon calling await connection.OpenAsync (where connection is a FirebirdSql.Data.FirebirdClient.FbConnection instance):

FirebirdSql.Data.Common.IscException: 'Error occurred during login, please check server firebird.log for details'

Looking at the server log, I see the following two errors, repeated various times:

DESKTOP-NAME Thu Jun 24 15:14:32 2021 Authentication error No matching plugins on server

DESKTOP-NAME Thu Jun 24 15:14:35 2021 INET/inet_error: read errno = 10054, client host = DESKTOP-NAME, address = 127.0.0.1/54653, user = Mason

I have no idea what this means, and some basic searching fails to turn up anything useful. Anyone know what I need to do to resolve this?

In case it's relevant, my connection string looks like this:

User=SYSDBA;Password=[my password];Database=[db name];DataSource=localhost;Port=3050;Dialect=3;Charset=UTF8;

Once again, I know the server is working correctly because I can connect to it with FB Maestro. The problem is clearly in my .NET code somewhere. I just have no idea where!

I have a pretty strange problem when trying to connect my C# program to an existing Firebird server.

First of all, this is reproducable with the default connection example from the Firebird documentation at https://github.com/FirebirdSQL/NETProvider/blob/master/Provider/docs/ado-net.md

I have a regression with a TCP\IP connection string post a firebird 3 migration from v2.5. The FirebirdClient version is 4.6.1 but I've tested with the latest stable version and it also doesn't work (v7.10.1).

The error message is "Your user name and password are not defined. Ask your database administrator to set up a Firebird login".

The stacktrace:

At the first glance, my problem seems to be quite trivial. I have to read data from Firebird's database, but this database was created by someone else. Raw binary data (like pictures) is stored in BLOB SUB_TYPE TEXT instead of BLOB SUB_TYPE BINARY and this is the problem, because Firebird ADO.NET Data Provider (FirebirdSql.Data.FirebirdClient 7.10.1) converts binary data to a string and I cannot find a proper method in this driver that returns binary data as a byte array from BLOB SUB_TYPE TEXT.

I was trying to reverse binary data converted to a string by provider but without success. I use this provider in the following way (simplified example):

I would like to update a list of rows given by a list of IDs. Normally, the parameters of the query can be passed via the parameter property. But if I pass a list of IDs, Firebird will not accept the query. I'm using the FirebirdSql.Data.FirebirdClient from NuGet.

Code (simplified):

I use FirebirdSql.Data.FirebirdClient to connect to a Firebird database (WPF desktop app).

Server Version: WI-V3.0.5.33220 Firebird 3.0, and ADO.net provider version is 7.5.0 (NuGet)

I created a user other than SYSDBA that only has read only access to the tables (only SELECT). Connecting with FlameRobin works without problems with this new user. However, when I specify this new user and corresponding read-only role in the FbConnectionStringBuilder class, I get a

"your username and password are not defined"

error. If I replace the new user by SYSDBA and corresponding password, the connection works.