Search code examples
c#odbcfirebirdfirebird-3.0

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

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

enter image description here

And here is the error enter image description here

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

enter image description here

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!

Solution

  • 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.