Firebird

• HeidiSQL version: 12.0
• Database type and version: 4.0 (Firebird)
• OS: Windows 10 Pro
• Describe the bug

Problem

Hey i wanted to connect to my local firebird database, but when i log in with my user and password i get this error with xnet. And ich dont know where this xnet is coming from because i put the localhost ip to the connecting.

Pic 1

Pic 2

Not sure but I would recommend to try out the TCP/IP version in the network type dropdown.

Thanks for answer, but its with TCP/IP still not working. Tryed localhost IP and i tested the file drive and i get this error, but with flamerobin i can connect to the database.

Did you put the file path in the "Databases" field?

thanks now its working, but now i get this error but the path is right and user, password also:

Oh that sounds strange. I would again retry with the TCP/IP network type, so the IP address is really used.

with TCP/IP i get the same error

Hi Anse, I have the same message on a remote server:

BTW, Firebird version 2.5.8 is installed on the server (Windows 10 on both server/client)

the firebird bd is running on a windows server. firebird version: 2.5.x Get the connection from heidiSQL: v12.4.x.

Problems found:

-The connection is closed unexpectedly. -tables will not load completely. -when executing sql queries these are not executed. (they stay running, it doesn't let close heidisql) -I have tried other clients, to check if there is any problem in the connection settings, but in other clients it works.

NOTE: it should be clarified that for the connection to be made from hedisql for the firebird 2.5.x version, libray must be used: "fbcliente-2.x.dll" since with the one that comes predetermined in heisql, it was impossible to connect. This version can be found from the official firebird page by specifically downloading the firebird 2.5.x version then you pass the fbcliente.dll to the heisql folder so that it can be selected.

Hello,

I'm trying to use HeidiSQL with Firebird for the first time and I'm having a problem. The Firebird version is 2.5.x installed on an Ubuntu Server 20.04.4 (terminal only). I put the appropriate dll in the HeidiSQL folder (C:\Program Files\HeidiSQL) but when trying to open the session the error window appears with the following message; connection failure; SQL error (0). See attached screenshot. This same database is working and being accessed with the same settings (ip, login, password, path,...) by a Delphi program using Unidac.

Thanks for any help.

I have the same problem as you,

The reason is that I installed Firebird 32-bit and Heidisql 64-bit.

Finally, reinstalling firebird 64 bit resolved the issue.