Problem with remote connexion on port 3050

[ricolebo]

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? ... 050#p86899 [^])
Didn't you add a bug by resolving the above one?
Could you fix this in a next release?

Regards,
Eric

[ViktorV]

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.

[ricolebo]

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

[ViktorV]

Thank you for the information.
We have reproduced the problem and investigation is in progress.
We will inform you when we have any results.

[ricolebo]

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

[ViktorV]

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.

[ricolebo]

Hello,

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

Thank you

[ViktorV]

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';

[ricolebo]

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 ?

[ViktorV]

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.