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
18
votes
1 answer

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

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"."…
Marcoscdoni
  • 955
  • 2
  • 11
  • 31
13
votes
4 answers

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…
Desolator
  • 22,411
  • 20
  • 73
  • 96
7
votes
2 answers

Firebird .NET provider and embedded server 3

I'm trying to use .NET Firebird Provider to connect to the embedded FB 3.0.1 server. As far as I know, (also written here (page 6)), there is no more fbclient.dll\fbembed.dll but a single client fbclient.dll used for remote and embedded access. But…
Barzo
  • 1,039
  • 1
  • 11
  • 37
5
votes
2 answers

How to execute transactions (or multiple sql queries) in firebird using c#

I have tried several ways, including on SO. The following MYSQL code does not work in Firebird: CREATE TABLE publications ( INT NOT NULL AUTO_INCREMENT , PRIMARY KEY (`id`), filename varchar(500) not null unique, title varchar(500) DEFAULT…
Damilola Olowookere
  • 2,253
  • 2
  • 23
  • 33
4
votes
2 answers

Retrieve Firebird ODS version in .Net

I am using firebird embedded v 2.5 and the .net FirebirdSql.Data.FirebirdClient. I need to be able to retrieve the ODS version for a given database. I have tried: private string GetOds(FbConnection connection) { using (var cmd = new FbCommand()) …
Chris Andrade
  • 43
  • 2
4
votes
1 answer

Firebird sends all events in .NET

Is it normal firebird server sends all registered event counts on raising any of registered event? By example on firebirds site I do this: class FirebirdListenerTest { public FirebirdListenerTest() { try { …
Fanda
  • 3,760
  • 5
  • 37
  • 56
3
votes
3 answers

Firebird dotnet batch inserts

can someone help me speed this up. I have a dataset (from a csv file) called dsresult and I want to pump it into a firebird table. Currently I am doing it 1 row at a time, but I would prefer to do this in batches of 500 rows. I am using the…
Crudler
  • 2,194
  • 3
  • 30
  • 57
3
votes
3 answers

Migrate Firebird 2.5 to 4.0 using ADO.Net provider

I just upgraded my DB to Firebird 4.0 and all seems to work when connecting to the DB using a database management tool. So now I try to connect, after making sure I've upgarded my ADO.Net to FirebirdSql.Data.FirebirdClient v8.0.1 (latest). Here is…
neggenbe
  • 1,697
  • 2
  • 24
  • 62
3
votes
2 answers

How to use events on an Embedded Firebird database connection?

If I connect to an embedded Firebird database, and create a remote event, I get System.NotSupportedException: Specified method is not supported.. on the constructor. _fbRemoteEvent = new FbRemoteEvent(_fbConnection); //_fbConnection is valid and…
Luc Jeanniard
  • 33
  • 3
3
votes
1 answer

How to close a connection with a firebird database

I'm developing a project using asp.net c# webforms framework 4.5, and I did a connection test on Firebird database, but when I close this connection it isn't closing, I used the following code to do it: string conDDNS; FbConnection…
Lucas Sousa
  • 141
  • 2
  • 5
3
votes
2 answers

Connecting to embedded FireBird database from C# app issue

I seem to have an issue with connecting to an embedded FireBird database from a sample C# app. Here's what I've got. static void Main(string[] args) { //Some constant parameters used to form up the connection string... #region…
Kirill Leontev
  • 10,641
  • 7
  • 43
  • 49
3
votes
2 answers

IDbConnection and Firebird

I want to test dapper micro orm with firebird db and I'm struggle with access to firebird. Firebird server is up and running, database is populated with some dummy data, and it is stored in c:\mydatabases\test.fdb Connection string is
user2783193
  • 992
  • 1
  • 12
  • 37
2
votes
0 answers

Getting intermittent InvalidCastException when using Firebird and Entity Framework with Data Context

I'm seeing the following error in my logs when calling one of my endpoints: An exception occurred while iterating over the results of a query for context type 'projectname.Data.DataContext'. System.InvalidCastException: Object cannot be cast from…
CSharpNewb
  • 181
  • 5
  • 15
2
votes
1 answer

How to execute a select query on database using C# Firebird and display it in shell?

I just started learning C# in Visual Studio and I got a task to do. I have to connect to a SQL database, execute a select query and display the results using Firebird. I have read through a lot of articles, but I got stuck since everyone is telling…
shade999
  • 79
  • 7
2
votes
1 answer

FirebirdSql Data Client I/O error during "CreateFile (open)" operation for file

One of our clients is getting this error very randomly. Once or twice a week. It has only been happening for the last month or so. Error message: I/O error during "CreateFile (open)" operation for file "ttt" Error while trying to open file Stack…
Netstrata
  • 75
  • 1
  • 7
1
2 3 4