Devart Forums

Good Morning.

I have two servers. A firebird 2.1 and another firebird 3.0.
I have a client.
When I configure my ibcconection to access the firebird 3.0 server it works but when I configure my ibconnection to access firebird 2.1, it does not work.

Configuration working by accessing firebird 3.0 server:
ibcconection.Server: 192.168.1.251
ibcconection.Port: 3050
ibcconection.Database: bancofb3.fdb
ibcconection.user: sysdba
ibcconection.password: masterkey
ibcconnectiion.clientlibrary: c: \ firebird30 \ fbclient.dll


Configuration not working by accessing firebird 2.1 server:
ibcconection.Server: 192.168.1.250
ibcconection.Port: 3050
ibcconection.Database: bancofb2.fdb
ibcconection.user: sysdba
ibcconection.password: masterkey
ibcconnectiion.clientlibrary: c: \ firebird21 \ fbclient.dll

Where am I going wrong?

Thank you.

Message: Unable to complete network request to host "192.168.1.250".
Failed to establish a connection.
No connection could be made because the target machine actively refused it. .

Actively refused points to a port error. Either firewall is blocking or port 3050 is not actually the listener port.

To solve the issue, please try to adding the IBCClasses module to uses clause and set the global variable ForceUsingDefaultPort to True. For example:

Tsagoth wrote: ↑Tue 30 Apr 2019 01:35 Actively refused points to a port error. Either firewall is blocking or port 3050 is not actually the listener port.

This works: isql -user sysdba -pas masterkey 192.168.1.250/3050:/bd/bancofb2.fdb.

Other tools, in addition to isql, connect at address 192.168.1.250/3050:/bd/bancofb2.fdb. (IBObjects, IBExpert)

The firewall is not blocking port 3050.
Firebird is listening on port 3050.

ViktorV wrote: ↑Tue 30 Apr 2019 06:53 To solve the issue, please try to adding the IBCClasses module to uses clause and set the global variable ForceUsingDefaultPort to True. For example:

Code: Select all

initialization
  ForceUsingDefaultPort := True;	

Your suggestion solved.
I changed the port to 3052 and the ForceUsingDefaultPort: = True parameter; it was not necessary.

I did not understand the purpose of the ForceUsingDefaultPort parameter in a connection string 192.168.61.250/3050:/bd/bancofb2.fdb

big_rid wrote: ↑Tue 30 Apr 2019 11:42

ViktorV wrote: ↑Tue 30 Apr 2019 06:53 To solve the issue, please try to adding the IBCClasses module to uses clause and set the global variable ForceUsingDefaultPort to True. For example:

Code: Select all

initialization
  ForceUsingDefaultPort := True;	

Your suggestion solved.
I changed the port to 3052 and the ForceUsingDefaultPort: = True parameter; it was not necessary.

It is good to see that the problem has been solved.
Feel free to contact us if you have any further questions about our products.

big_rid wrote: ↑Tue 30 Apr 2019 11:53 I did not understand the purpose of the ForceUsingDefaultPort parameter in a connection string 192.168.61.250/3050:/bd/bancofb2.fdb

If the default port is 3050, it will be cut from the connection string sent to the server. This was done for compatibility with specific versions of InterBase (Firebird). But some other versions of InterBase (Firebird) don't work correctly if the default port is not specified, so we introduced ForceUsingDefaultPort option.
If the TIBCConnection.Database property is set to 192.168.61.250/3050:/bd/bancofb2.fdb and the ForceUsingDefaultPort property is set to False, then the string passed to the server will be '192.168.61.250:/bd/bancofb2.fdb' if ForceUsingDefaultPort is set in True - '192.168.61.250/3050:/bd/bancofb2.fdb'

Thanks.

Thank you for the interest to our product.
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.

I got this informationlol beans