Stack Overflow
Stack Overflow

Questions tagged [firebird-.net-provider]

ADO.NET provider for Firebird is a C# library for connecting Microsoft .Net programs with Firebird SQL server. Use this tag for question on connecting and using Firebird from C# applications using the FirebirdSql.Data.FirebirdClient (Firebird ADO.net provider) driver

58 questions
1
vote
1 answer

How to inspect nbak state of a Firebird database

Is there a way in C# to inspect the nbak state of a Firebird database? The state in the database header would be set to nbak_state_diff or nbak_state_normal. But how do I actually read this value?
Kjell Rilbe
  • 1,331
  • 14
  • 39
1
vote
1 answer

Firebird Listener like TableDependency in SQL Server

I am working on a C# (Visual Studio 2019) Form application and I need to fetch some table data from a Firebird database. For SQL Server, I am doing it successfully with TableDependency but in Firebird I am trying to do something similar to listen…
Jugnu Khan
  • 63
  • 3
  • 9
1
vote
2 answers

How to get return value from query with Dapper?

I'm trying to get a return value from an insert query using Dapper. Here's how I try to make it work: // the query with a "returning" statement // note : I have a trigger that sets the Id to a new value using the generator IF Id is null... string…
neggenbe
  • 1,697
  • 2
  • 24
  • 62
1
vote
2 answers

Problems with making backup with Firebird package

I'm trying to develop a backup with a firebird database using the firebird package but it gives me an error. FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.UserID = "SYSDBA"; cs.Password = "masterkey"; …
Michael Eriksen
  • 167
  • 1
  • 3
  • 13
1
vote
2 answers

FirebirdSql Error occurred during login, please check server firebird.log for details

I am trying to connect and read data from Firebird database using the FirebirdSQL .net provider (using FirebirdSql.Data.FirebirdClient). Here is the code: FbConnection viewdataConnection=new FbConnection(); viewdataConnection.ConnectionString =…
Vikas Kottari
  • 495
  • 2
  • 10
  • 24
1
vote
1 answer

EF Core - Firebird Migration auto-increment problem

I'm testing the migration with EF Core with MSSQL-Server and Firebird 3.0. I create a new table with a few fields. The key-field has the property .ValueGeneratedOnAdd(), but the key-field in the Firebird database doesn't get an auto-increment…
Henning
  • 421
  • 2
  • 11
  • 22
0
votes
1 answer

Connection timeout in Firebird Server 3

I'm connecting to a Firebird SQL Server version 3 with a C# application using Firebird .NET Client 9.1.1. Once the application is started 3 connections to the server are established using a connection pool. When the application quits in a normal…
anli
  • 515
  • 6
  • 9
0
votes
0 answers

Trouble when trying to make a query with entity framework and .net6 and firebird database

Here is the mapping: builder.Property(c => c.Nome) .IsRequired() .HasMaxLength(100) .HasColumnName("NOME"); builder.Property(c => c.Apelido) .IsRequired() .HasMaxLength(100) .HasColumnName("APELIDO"); Here is my…
Duarte_hrd
  • 16
  • 1
0
votes
1 answer

C# Firebird FbDataReader Object reference not set to an instance of an object

I'm starting a Windows Forms program from Task Scheduler under specific user used only for that. I have some queries to the database executed by FbDataReader and all queries execute work OK, except sometimes (not always, that is the most confusing…
A. Celarc
  • 1
  • 1
0
votes
0 answers

Avoid deadlock on Firebird

I would like to avoid DeadLock issue in code. I read the way is to use FOR UPDATE WITH LOCK also FbTransactionBehavior.Wait. But my second transaction, despite it is waiting for the first one to finish, always dies by DeadLock. I wrote a very simple…
dani herrera
  • 48,760
  • 8
  • 117
  • 177
0
votes
0 answers

MS Visual Studio 2022 doesn't connect in Firebird 4

I migrated my Firebird 2.5 database to Firebird 4.0 and now I can not connect the MS Visual Studio 2022, I've tried several things but nothing works, someone has an idea how to solve this? I just keep getting the message: connection rejected by…
Marcos Corsato
  • 1
0
votes
0 answers

Strange Behaviour moving from firebird sql version 2.5 to version 4

I have a Windows application written in C# using embedded firebird sql version 2.5.5.26952, which I am re-working it to update to embedded firebird sql version 4.0.0.2496. I have update the fdb file to the new version,and all the tables and sprocs,…
altazu
  • 121
  • 7
0
votes
0 answers

Asp.Net ADO Firebird System.ArgumentOutOfRangeException: operation=0

I'm having a problem on a system that is running on IIS 10.0.14393.0 with Framework 4.6.1. System.ArgumentOutOfRangeException: operation=159 Parameter name: operation The number "159" is random, sometimes it is "0" or even very large…
Osvaldo G. Da Cruz Júnior
  • 1
  • 1
0
votes
1 answer

How to query with firebird parameters and conditions

I'm trying to build a function on a single button, to search my database based on the selections that are made in multiple comboboxes. I have four comboboxes that can be null or valued. My final result should be to be able to filter the datagridview…
Rico Domin
  • 1
  • 1
0
votes
1 answer

Can't connect XtraReport to Firebird Database

I'd like to create an XtraReport connected to a Firebird database. Actually I have done this before, with no problem. But in this new project when I create the connection I get the error "Could not load type…
CMorgado
  • 73
  • 1
  • 6
1 2
3
4