I have usually used EDBSRVR.exe for all LAN and WAN connections to my Delphi Apps.

In order to add some functionality I have developed my own customized version of EDBSRVR.

It works really well until it comes to connection over a WAN, at which point the behaviour changes. I cannot access my own Server program via WAN, although all settings on the machine identical, I can access EDBSRVR.

I have EDBSRVR set up on a good number of WAN-servers, with Firewall set up etc., so I know how to do that part of the process. The same settings for my App just give an error.

Adam


I'm not going to be able to help you but please tell others what the error is. Someone may understand it.

The other point I would make is that if the standard EDBSRVR works and your's doesn't it has to be somewhere in your modifications. I do not envy the suffering at debugging something like this. Quick question: can the mods be implemented in chunks and tested or is it an all or nothing thing?

Roy Lambert

On 3/23/2022 7:30 AM, Adam Brett wrote:
> I have usually used EDBSRVR.exe for all LAN and WAN connections to my Delphi Apps.
>
> In order to add some functionality I have developed my own customized version of EDBSRVR.
>
> It works really well until it comes to connection over a WAN, at which point the behaviour changes. I cannot access my own Server program via WAN, although all settings on the machine identical, I can access EDBSRVR.
>
> I have EDBSRVR set up on a good number of WAN-servers, with Firewall set up etc., so I know how to do that part of the process. The same settings for my App just give an error.

Would need some more info on what errors are as well as some info on how
your own server works exactly.

Couple of questions

1. if you telnet into port your server listen over wan do you get a
connection at least ?

2. Only other thing i can think of is that your server is not routing
responses back properly in terms of an actual IP (i.e. is firewall that
wan connection comes thru also default gateway for PC or not )

Raul

Thanks for these messages,

The Error is:

First stage Database Connection Error:
Session Connection Failed LINE: uDB3044
ElevateDB Error #1100 A connection to the server at '18.134.27.33' cannot be established ('Socket error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
(10060), on API 'connect'')

So pretty much "there's nothing there".

The weird thing is I have EDBSRVR running on the exact same server machine, which the exact same firewall settings and it works just fine. Also, my own SRVR is basically a cut-and-paste version of the EDB Source code with some very minor adjustments, so I am struggling to see why it behaves differently.

Is the EDBSRVR "signed" in some way so Windows treats it differently as it goes through the Firewall?

I am really not a networks expert.

I can't see how my compiled version is different enough to the EDB version for it to fail in this way.

Hi Adam,

<< Adam Brett wrote:

First stage Database Connection Error:
Session Connection Failed LINE: uDB3044
ElevateDB Error #1100 A connection to the server at '18.134.27.33' cannot be established ('Socket error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
(10060), on API 'connect'')  >>

I have been using a custom EDB Server for years.  I created it so I could add custom functionality like automatic server discovery.  It doesn't use any of the EDBSrvr code - only the TEDBEngine component.

I'm not really familiar with WANs but I'll try to help if I can. I'd imagine that the server connects through a local router?

I'm probably showing my ignorance here but is 18.134.27.33 the IP Address of the server, or is it a Public IP Address?  If it's a public address, is there a port forward rule for the custom server?

= Steve