Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
6
Erster Beitrag:
vor 6 Jahren, 2 Monaten
Letzter Beitrag:
vor 6 Jahren, 2 Monaten
Beteiligte Autoren:
Jimbo , DanM

WD16 - How to Connect to HFCS on LAN?

Startbeitrag von DanM am 29.04.2012 16:17

There sure are a lot of help screens for Connection!

Currently I connect to the HFCS on my desktop when developing and I am also able to connect to my webserver out on the internet but I have never tried connecting locally through our LAN.

I am sure what I want to do is fairly simple I just cannot find the right help screen / example.

I have WinDev set up on my Desktop and use HFCS.

I want to allow another user in our location to run the WinDev application from their desktop on a local network to connect to the HFCS database on my desktop.

A few questions ...

1. Do I need to share files / directory? If so, which ones

(Currently the HFCS DB is located on my machine in C:\Program Files\PC Soft\HyperFileSQL Server)

I have made several guesses ... but nothing has worked yet

Do I need to use the function ?? ...

ResConnection = NetworkConnect("E:", "\\SharedDocuments\Files")

Any suggestions to point me to a help screen or forum post are greatly appreciated!

Antworten:

Quote
DanM
There sure are a lot of help screens for Connection!

Currently I connect to the HFCS on my desktop when developing and I am also able to connect to my webserver out on the internet but I have never tried connecting locally through our LAN.

I am sure what I want to do is fairly simple I just cannot find the right help screen / example.

I have WinDev set up on my Desktop and use HFCS.

I want to allow another user in our location to run the WinDev application from their desktop on a local network to connect to the HFCS database on my desktop.

A few questions ...

1. Do I need to share files / directory? If so, which ones

(Currently the HFCS DB is located on my machine in C:\Program Files\PC Soft\HyperFileSQL Server)

I have made several guesses ... but nothing has worked yet

Do I need to use the function ?? ...

ResConnection = NetworkConnect("E:", "\\SharedDocuments\Files")

Any suggestions to point me to a help screen or forum post are greatly appreciated!


Hi, no, HFCS is a database like most others and all PCs within the LAN connect to HFCS via IP-address:port address. You have to open ports 4900 and 4999 to allow for access from other PCs (Firewall!!). The client program has to connect to your PC via HDescribeConnection(...) and HOpenConnection(..). You should NOT use a connection in your analysis!!!! Just define the files for HyperFile Classic! I made an example of how that works here http://www.windev.at/html/hfclassichfsql.html Regrads, Guenter

von Jimbo - am 29.04.2012 16:54
Thank you Guenter

Dan

von DanM - am 29.04.2012 17:12
Guenter,

OK ... I am a little out of my element here so I could use a little more direction please ...

I opened port 4900 & 4999 and tested to make sure they are open using

netstat -an at the commandline and it says ...

PROTO : TCP
State : Listening

so I figure that means the ports are open

Then I run your project and I am getting the following error:

Unable to connect to 192.168.1.4:4900
Connection to server failed
Error Code 74000

I used the 192.168.1.4 as it is the IP for the local machine according to my router

I also tried using Dan-PC:4900 as it is the name if the machine... same error

Any ideas what I am doing wrong?

Thanks ... Dan

von DanM - am 29.04.2012 18:28
Quote
DanM
Guenter,

OK ... I am a little out of my element here so I could use a little more direction please ...

I opened port 4900 & 4999 and tested to make sure they are open using

netstat -an at the commandline and it says ...

PROTO : TCP
State : Listening

so I figure that means the ports are open

Then I run your project and I am getting the following error:

Unable to connect to 192.168.1.4:4900
Connection to server failed
Error Code 74000

I used the 192.168.1.4 as it is the IP for the local machine according to my router

I also tried using Dan-PC:4900 as it is the name if the machine... same error

Any ideas what I am doing wrong?

Thanks ... Dan


Hi Scott,
- did you input a database name?
- Admin-name + password ok?
I tested it, just to make sure that it works. It does, indeed.
At first, it should work on your lokal PC.
I try to give you access to our server.
Regards, Guenter

von Jimbo - am 30.04.2012 05:42
Quote
DanM
Guenter,

OK ... I am a little out of my element here so I could use a little more direction please ...

I opened port 4900 & 4999 and tested to make sure they are open using

netstat -an at the commandline and it says ...

PROTO : TCP
State : Listening

so I figure that means the ports are open

Then I run your project and I am getting the following error:

Unable to connect to 192.168.1.4:4900
Connection to server failed
Error Code 74000

I used the 192.168.1.4 as it is the IP for the local machine according to my router

I also tried using Dan-PC:4900 as it is the name if the machine... same error

Any ideas what I am doing wrong?

Thanks ... Dan



Hi Dan (sorry for the mix-up of names!), just for a test:

1 - press Shift-key and hold
2 - start the test application
3 - User = Scott (this is a linux server, it's case sensitive!)
4 - password: Daughtry
5 - computer: 81.19.151.135:4900
6 - database: WDTest
7 - click button [ Save Ini file .. ]

You should connect to database WDTest and being able to input new names, delete them, see them in the Table ..

When starting the application a second time (without holding the shift key!) it will automatically connect to this database due to the stored contents of the ini file.

Regards,
Guenter

von Jimbo - am 30.04.2012 06:19
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.