Problem with remote connexion on port 3050

Problem with remote connexion on port 3050

Postby ricolebo » Tue 18 Nov 2014 16:01

Hello

Problem connecting Firebird Database
with dbexpida40.dll driver under delphi XE5


Here is the context:
--------------------
1-distant Firebird 2.5 Server database :
192.168.0.205/3050:/home/base/mydb.fdb

2-my PC :
3 firebird versions installed as application.
C:\Firebird\Firebird_1_5\firebird.conf
RemoteServicePort = 3015

C:\Firebird\Firebird_2_1\firebird.conf
RemoteServicePort = 3021

C:\Firebird\Firebird_2_5\firebird.conf
RemoteServicePort = 3025

3-I have this Firebird default instance regsitry key :
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Firebird Project\Firebird Server\Instances]
"DefaultInstance"="C:\\Firebird\\Firebird_1_5\\"




When executing my application with dbexpida.dll (4.3), with db connection SQLConnection1.Params.Values['database']:='192.168.0.205/3050:/home/base/mydb.fdb',
I have an error message "Unabled to complete network request to host "192.168.0.205".

It neither works with 4.5 version but worked with the 4.1.
I seems that if the default connection port is specified in the connection string, you consider that
the default local server is used and read the firebird.conf of the default server.
But in my example, the server is not a local one, we don't need to read local configuration, isn't it?

I saw on your forum that a developper found the "inverse" problem
(cf http://forums.devart.com/viewtopic.php?f=26&t=25584&p=86899&hilit=3050#p86899 [^])
Didn't you add a bug by resolving the above one?
Could you fix this in a next release?

Regards,
Eric
ricolebo
 
Posts: 30
Joined: Tue 12 Feb 2008 12:30

Re: Problem with remote connexion on port 3050

Postby ViktorV » Wed 19 Nov 2014 12:34

This error can occur due to incorrect specifying of Firebird remote server IP in SQLConnection1.Params.Values['DataBase'], incorrect port or server inaccessibility from external network (server is not running, incoming connection to this port is denied).
Data from firebird.conf files on your computer are not used in any way when establishing connection to a remote PC. Please check all the connection parameters and Firebird server configuration on the remote PC.
ViktorV
Devart Team
 
Posts: 1869
Joined: Wed 30 Jul 2014 07:16

Re: Problem with remote connexion on port 3050

Postby ricolebo » Wed 19 Nov 2014 13:33

Hi,

sorry but,
my remote server is ok: can access from my own pc, fbserver is running on default port (3050).

With 2 same applications , the first one using DBexpida 4.1 , the second one using 4.5 version.
Both read the connection string in the same ini file, so that , they have the same database connection string (192.168.0.205/3050:/home/base/mydb.fdb).

The application using 4.1 version work perfectly (connection to DB is ok).
The application using 4.5 version doesn't connect : "Unabled to complete network request....".

If I used a sniffer to spy used ports, I see that the 4.5 version doesn't use the 3050 port (specified in the connection string) but the port define in the firebird.conf (3015) of the DefaultInstance registry key.

Did you try to reproduce using the context mentionned in the my first post?

Regards,
Eric
ricolebo
 
Posts: 30
Joined: Tue 12 Feb 2008 12:30

Re: Problem with remote connexion on port 3050

Postby ViktorV » Thu 20 Nov 2014 10:45

Thank you for the information.
We have reproduced the problem and investigation is in progress.
We will inform you when we have any results.
ViktorV
Devart Team
 
Posts: 1869
Joined: Wed 30 Jul 2014 07:16

Re: Problem with remote connexion on port 3050

Postby ricolebo » Tue 10 Mar 2015 15:49

Hello,

It's just to know when you have plan to release the next build of the driver.
I really need the driver without this connection bug.

Thank you
Eric
ricolebo
 
Posts: 30
Joined: Tue 12 Feb 2008 12:30

Re: Problem with remote connexion on port 3050

Postby ViktorV » Wed 11 Mar 2015 07:21

The new buid of dbExpress driver for InterBase and Firebird release is planned for within a month. If you want to get this fix before the next dbExpress driver for InterBase and Firebird version is released, please provide your license number and IDE version to viktorv*devart*com and we will send you a night build.
ViktorV
Devart Team
 
Posts: 1869
Joined: Wed 30 Jul 2014 07:16

Re: Problem with remote connexion on port 3050

Postby ricolebo » Mon 27 Apr 2015 08:14

Hello,

It's just to say you that the problem is not fixed with new version 4.6.9.0

Thank you
ricolebo
 
Posts: 30
Joined: Tue 12 Feb 2008 12:30

Re: Problem with remote connexion on port 3050

Postby ViktorV » Mon 27 Apr 2015 09:36

The ForceUsingDefaultPort option was added for the driver. Its default value is False. To solve the issue, please set it to True. For example:
Code: Select all
SQLConnection.Params.Values['ForceUsingDefaultPort'] := 'True';
ViktorV
Devart Team
 
Posts: 1869
Joined: Wed 30 Jul 2014 07:16

Re: Problem with remote connexion on port 3050

Postby ricolebo » Mon 27 Apr 2015 10:08

Thank you Viktor,

It works now with this new parameter.
But just one question : Why you don't take simply the port specified in the connection string and just use only default port when the port isn't specifed ?
ricolebo
 
Posts: 30
Joined: Tue 12 Feb 2008 12:30

Re: Problem with remote connexion on port 3050

Postby ViktorV » Mon 27 Apr 2015 11:36

Our driver supports various versions of Firebird and InterBase. Some versions of these DBMSs don't allow to explicitly specify the port on connection to the server, therefore we have added such restriction in the driver.
ViktorV
Devart Team
 
Posts: 1869
Joined: Wed 30 Jul 2014 07:16


Return to dbExpress driver for InterBase & Firebird