Two firebird servers, one works other not.
Two firebird servers, one works other not.
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.
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.
Re: Two firebird servers, one works other not.
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. .
Failed to establish a connection.
No connection could be made because the target machine actively refused it. .
Re: Two firebird servers, one works other not.
Actively refused points to a port error. Either firewall is blocking or port 3050 is not actually the listener port.
Re: Two firebird servers, one works other not.
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;
Re: Two firebird servers, one works other not.
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.
Re: Two firebird servers, one works other not.
Your suggestion solved.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;
I changed the port to 3052 and the ForceUsingDefaultPort: = True parameter; it was not necessary.
Re: Two firebird servers, one works other not.
I did not understand the purpose of the ForceUsingDefaultPort parameter in a connection string 192.168.61.250/3050:/bd/bancofb2.fdb
Re: Two firebird servers, one works other not.
It is good to see that the problem has been solved.big_rid wrote: ↑Tue 30 Apr 2019 11:42Your suggestion solved.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;
I changed the port to 3052 and the ForceUsingDefaultPort: = True parameter; it was not necessary.
Feel free to contact us if you have any further questions about our products.
Re: Two firebird servers, one works other not.
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'
Re: Two firebird servers, one works other not.
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.
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.
Re: Two firebird servers, one works other not.
I got this informationlol beans