Interbase database connection error

Question

Good afternoon,

I’m having trouble configuring the database connection in Delphi 10.3 Community Edition. I am trying to connect to Interbase by Firedac and gives the error below when testing the connection.

ERROR:

[Firedac][Phys][IB]Unable to complete network request to host "DESKTOP-JH05R6K". Failed to locate host machine. Undefined service gds_db/tcp..

After I put this line below in windows services file started giving error below:

gds_db 3050/tcp # Firebird

ERROR:

[Firedac][Phys][IB]Unable to complete network request to host "DESKTOP-JH05R6K/3050". Failed to Establish a Connection. None connection might be made because the target machine refused them actively.

Does anyone know how to fix this mistake?

Thank you in advance.

Answer 1

How are you passing the connection parameters? Try something similar to the connection below

Conexao: TFDConnection;
....
Conexao.Close;
Conexao.Params.Values['Server'] := 'localhost';
Conexao.Params.Values['Port'] := '3050';
Conexao.Params.Values['Database'] := 'C:\Banco\Banco.gdb';
Conexao.Params.Values['User_Name'] := 'Usuario';
Conexao.Params.Values['Password'] := 'Senha';
Conexao.Open;