Error trying to connect a firebird database with ODBC or C# application

Question

I'm trying to connect my c# application in a Firebird database. Using the user and password I got works on firebird sql tool. But when I go to my c# app, I got an error. So I went to the ODBC drivers, trying to connect and I got the same error. Here is the odbc screen

And here is the error

Like I said, it really works with firebird ISQL tool. I already changed a few configs into the firebird.conf file. I had to set

WireCrypt = Enabled

for resolve a previously problem, and now I'm trying this one but without success

AuthServer=Srp,Legacy_Auth

Any help guys? Thanks in Advance!

EDIT

The error in C# application is exactly the same of ODBC.

Stacktrace:

   at FirebirdSql.Data.Client.Managed.GdsConnection.Identify(String Database)
   at FirebirdSql.Data.FirebirdClient.ClientFactory.CreateManagedDatabase(FbConnectionString options)
   at FirebirdSql.Data.FirebirdClient.ClientFactory.CreateDatabase(FbConnectionString options)
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()

FirebirdSql.Data.FirebirdClient 5.11.0.0

Server version

I`m not referencing fbclient.dll yet! But I have it after install the Firebird. The version is 3.0.2.32703

Thanks for now!

Which version of the Firebird ADO.net driver are you using in your C# application, which version of the ODBC driver, and which version of fbclient.dll is it using? Exactly which version of Firebird 3 do you have? Why focus on the ODBC error when your primary problem is with the C# application? Specify exactly which error you get in your C# application (full stacktrace, please). — Mark Rotteveel
Because the error in my C# application is exactly the same of ODBC! — Leandro De Mello Fagundes
unrelated: Character Set as "NONE" is very dangerous setting! Set it to some meaningful value like UTF-8 — Arioch 'The

Leandro De Mello Fagundes Leandro De Mello Fagundes · Accepted Answer · 2017-10-04T18:22:08

I solved my problem by just going to Firebird folder (windows explorer) and changing the security for everyone (full permission to everyone). So my app and odbc started working. I'm sure it's not the right way but I solved my problem for now. Waiting for better answers.

Error trying to connect a firebird database with ODBC or C# application

1 Answers