Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 8 of 8 total
Thread ElevateDBError #1100 A connection to the server 127.0.0.1 cannot be established
Tue, Oct 9 2018 5:53 AMPermanent Link

Iztok Lajovic (1)

I get this error running ElevateDB as remote on my machine.

Further the text of this error is: 'Socket error: An existing connection was forcibly closed by remote host (10054), on API 'recv').

What do I have to get ElevateDB running first on my computer and later on server.

Regards
Iztok Lajovic
Tue, Oct 9 2018 7:11 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

1


Have a look in the general newsgroup back in 2014 there was a post about this which should be relevant

From: Lee Mc Cauley
Subject: Remote connection error 1100
Date: Wed, 4 Jun 2014 21:49:11 -0400
Lines: 11
Message-ID: <6CFBF075-141B-41D2-8F95-AA86228B1090@news.elevatesoft.com>
Newsgroups: elevatesoft.public.elevatedb.general
Path: www.elevatesoft.com

..
Roy Lambert
Tue, Oct 9 2018 8:52 AMPermanent Link

Iztok Lajovic (1)

Roy, thank you for your reply.

I disabled Firewall: the same error.

I changed IP address 127.0.0.1 to my IP address, which I received via IPCONFIG: the same error

I put remoteHost name instead of IP address: the same error

Is there any other possibility to run ElevateDB except to run it locally?

Regards
Iztok Lajovic
Tue, Oct 9 2018 10:38 AMPermanent Link

Adam Brett

Orixa Systems

Iztok Lajovic

EDB Server is running on your machine, the error message indicates that it is receiving the request, but is "actively refusing" it. Therefore, something in how the program is accessing EDB Server is not set correctly.

The error is annoyingly vague, so it is hard to know exactly what you have done wrong, but be sure that you should be able to get a connection.

1. Is SessionType = ANSI / UNICODE matched between program and EDB Server?

2. Are all settings in the Engine and Session components of the program set correctly to match the EDB Server? Particularly Config-Folder, Port, RemoteAddress,

3. Try to connect to EDB Server from EDB Manager. Then duplicate the settings you have used for this in your program.

Sorry if I am saying things you have already tried ...
Tue, Oct 9 2018 11:04 AMPermanent Link

Iztok Lajovic (1)

Adam, thank you for help which was the right one.

In a local mode I have the ANSI character set but for remote one I have to switch to Unicode character set. Maybe you know how I can unify both modes to have ANSI character set?

Thank you once more
Iztok Lajovic
Tue, Oct 9 2018 1:48 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Iztok,

<< In a local mode I have the ANSI character set but for remote one I have to switch to Unicode character set. Maybe you know how I can unify both modes to have ANSI character set? >>

Are you purposefully switching to using Unicode with the EDB Server ?  Is the database that you're accessing a Unicode or ANSI database ?

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Oct 10 2018 2:50 AMPermanent Link

Iztok Lajovic (1)

Tim,

>Are you purposefully switching to using Unicode with the EDB Server ?  Is the database that you're accessing a >Unicode or ANSI database ?

No, and I cannot recall when I did it. I want to have in both session types ANSI database.

To reach it I first deleted the databases and EDBConfig.EDBCfg also. When I started edbmgr.exe the EDBConfig.EDBCfg was created. Then I wanted to connect remote session to ANSI character set, but error #1100 occurred saying that 'connection was forcibly closed by remote host'. After changing ANSI character set to UNICODE character set I successfully connected the session. Obviously edbmgr found somewhere information about remote session type and requested character set. I cannot imagine where information about remote session exists besides in EDBConfig.

Regards
Iztok Lajovic
Wed, Oct 10 2018 5:00 AMPermanent Link

Adam Brett

Orixa Systems

Iztok

If you open EDB Server, "Stop" it and click on the "Change Settings" link, you will then be able to switch the Character-set of the server.

Unless you really need ANSI, I think it is fine to keep both as UNICODE, ie I would suggest you might want to change your program to use UNICODE, rather than changing your server to ANSI.

(But please back up data first!! Smile)
Image