Firebird远程连接失败 [英] Firebird remote connection failure

问题描述

我有一个cpp应用程序，用于从firebird SQL服务器读取数据。当我将端口从3050更改为3053时，它显示错误，如



DB错误：0：无法完成主机192.168.1.47的网络请求。

无法建立连接。

未知Win32错误10060

无效的连接字符串属性

conf文件更改为



＃类型：字符串，整数

＃

RemoteServiceName = gds_db

RemoteServicePort = 3053



是否需要进行任何修改才能解决此问题？如果端口是3050，应用程序可以读取数据。



我尝试过：



Fb连接字符串是



Driver = Firebird / InterBase（r）驱动程序; DBNAME = 192.168.1.47：CWNPFB; PORT = 3053; UID = SYSDBA ; PWD = ********

解决方案

问题在于您的连接字符串：



从连接字符串中删除PORT = 3053（这会导致无效的连接字符串属性消息）

修改DBNAME =  192 。 168 。 1 。 47 ：CWNPFB到DBNAME =  192 。 168 。 1  .47 / 3053：CWNPFB 

（指定正确的端口）

您可能还想注释掉（或删除）行RemoteServiceName = gds_db ，因为你现在指示Firebird听 gds_db（== port 3050 ），和 code-digit> 3053

。我相信它通常会听取配置文件中配置的最后一个，但我不确定总是这样。



礼貌：Mark Rotteveel

I've a cpp 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

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

What I have tried:

Fb connection string is

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

解决方案

The problem is with your connection string:

Remove PORT=3053 from the connection string (this causes the "Invalid connection string attribute" message)

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 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.

courtesy : Mark Rotteveel

这篇关于Firebird远程连接失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！