Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
4
Erster Beitrag:
vor 7 Monaten, 2 Wochen
Letzter Beitrag:
vor 7 Monaten, 2 Wochen
Beteiligte Autoren:
GuenterP, kingdr, Fabrice Harari

HOpenConnection ...

Startbeitrag von GuenterP am 05.04.2017 16:55

Hi,

just for testing, I installed the HFSQL C/S version 22 locally on my desktop PC - using a WINDEV program from version 21. It uses a 500 Gb SSD disk and Windows 10 prof. Theoretically, the connection should be possible within a tenth of a second. Surprise, it takes HOpenConnection(..) about 13 seconds for to make the connection!

After that I tried to open the HFSQL Control Center to look at the database. Same experience! It takes about 15 seconds to open the CC.

A connection to our remote server / HFSQL Server version 21065f takes about 4 seconds

Now, is this a problem on my PC or a problem with version 22 ??

Antworten:

Hi Guenter

in my experience, this comes from a DNS resolution problem on your network.
To verify if that's the case, try connecting with either localhost, the computer name or the IP address of the computer

If one of the 3 is fast and another slow, you've got windows DNS resolution to thank for.

You can solve (work around) that problem by adding the IP address in the HOSTS file (a whole experience in itself)

Best regards

von Fabrice Harari - am 05.04.2017 18:12
Hi

I guess it'd be the port # issue with Windows defender/AV as
I have no problem at all with w10-64 locally and remotely either 21/22.

Hm..., dun like w10 autoUpdate and sometime I got stuck with dongle not
being recognised and good after some time, weird...

HTH

King

von kingdr - am 05.04.2017 23:40
Thank you Fabrice! localhost:4900 did it, but neither the local IP nor the PC's name.

von GuenterP - am 06.04.2017 05:53
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.