CODEWITHSUNDEEP
c++sqlfirebirdfirebird2.5
MKallarakkal
MKallarakkal

Reputation: 315

Firebird remote connection failure

I have a C++ application that used to read the data from the Firebird SQL server.

when I changed port from 3050 to 3053 it shows error like

DB Error : 0 : Unable to complete network request to host "192.168.1.47".
Failed to establish a connection.
unknown Win32 error 10060
Invalid connection string attribute

conf file is changed like

# Type: string, integer
#
RemoteServiceName = gds_db
RemoteServicePort = 3053

Fb connection string is

Driver=Firebird/InterBase(r) driver;DBNAME=192.168.1.47:CWNPFB;PORT=3053;UID=SYSDBA;PWD=********

Is there any modification is required to solve this? Application can read the data if the port is 3050.

Upvotes: 2

Views: 3188

Answers (2)

Mark Rotteveel
Mark Rotteveel

Reputation: 108941

The problem is with your connection string:

You need to

  1. Remove PORT=3053 from the connection string (this causes the "Invalid connection string attribute" message)
  2. Modify DBNAME=192.168.1.47:CWNPFB to DBNAME=192.168.1.47/3053:CWNPFB (to specify the right port)

You might also want to comment out (or remove) the line RemoteServiceName = gds_db, because you are now instructing Firebird to listen on gds_db (== port 3050), and not on port 3053. I believe it usually listens on the last one configured in the config file, but I'm not sure that is always the case.

Upvotes: 1

MBDev
MBDev

Reputation: 442

Is your firewall configuration correct for port 3053? Another service may runs on this special port.

You could do the following steps.

  1. Try to run the application on the database server, please change the IP to 127.0.0.1 or localhost.

  2. If step (1) works: check out the firewall

  3. If step (1) doesn't work: maybe try another port, check whether Firebird is running

Upvotes: 0

Related Questions