Page 2 of 2
Re: FWH, VPN and SMB
Posted: Mon Apr 20, 2020 6:40 pm
by TimStone
When you use DBF, your application must transfer a lot of data to the workstation. Multiple VPN's will surely slow this down. Remember, in this mode you are using Microsoft Windows Peer To Peer networking which is not robust.j
If you have Advantage Database Server ( not the LOCAL version, but licensed remote ), then the data processing takes place at the server, and only essential data is transfered across the VPN. This is normal Client/Server technology.
You can get a 30 day free trial of Advantage Database Server. The only modification to your code will be in the MAIN( ) function where you make the RDD available.
I have clients who use this method and speed is not an issue. Since you can try it at no cost, you might find this to be the better solution.
My startup code reads from an ini type file to know if it should use RDDCDX, or RDDADX and if it is Remote or Local mode.
We done this for the past 20 years.
Tim
Re: FWH, VPN and SMB
Posted: Mon Apr 20, 2020 6:45 pm
by driessen
Tim,
Thanks a lot for your advice.
I start trying it out immediately.
Re: FWH, VPN and SMB
Posted: Mon Apr 20, 2020 7:06 pm
by driessen
Tim,
I just installed the evaluation version of ADS 12.0.
I use this code to select RDDCDX
To what do I have to change my code?
But how about converting the existing files?
Thanks.
Re: FWH, VPN and SMB
Posted: Mon Apr 20, 2020 8:02 pm
by Otto
Michel,
Tim speaks of something else. I suggested RDP to you - we have running hundreds of systems with WINHOTEL.
The databases and programs are installed on the SERVER.
No data is sent over the network. Only the screen contents.
If you want, you can install and test a demo of your software on one of our servers. I set up some users for you.
Best regards,
Otto
Re: FWH, VPN and SMB
Posted: Mon Apr 20, 2020 8:11 pm
by driessen
Otto,
I know what you mean. I have customers working that way, using RDP.
But in this case, there is no server available to which several users can connect together using RDP.
Re: FWH, VPN and SMB
Posted: Mon Apr 20, 2020 8:31 pm
by Otto
Michel,
you can install WINDOWS SERVER 2019 on a WINDOWS 10 as a virtual machine.
The download version works for 120 days without licenses.
Best regards
Otto
Re: FWH, VPN and SMB
Posted: Mon Apr 20, 2020 8:37 pm
by driessen
Otto,
Thanks a lot for the tip.
Didn't know that.
Re: FWH, VPN and SMB
Posted: Mon Apr 20, 2020 8:54 pm
by Antonio Linares
Michel,
This is a very basic ads.prg example that is included with mod_harbour:
Code: Select all | Expand
#include "ads.ch"
function Main()
RddRegister( "ADS", 1 )
AdsSetServerType( 1 ) // ADS_LOCAL_SERVER
RDDSetDefault( "ADS" )
USE clients VIA "ADS"
? FieldName( 1 )
? FieldGet( 1 )
? RecCount()
USE
return nil
Here you have the Harbour ADS support docs:
https://harbour.github.io/doc/rddads.html
Re: FWH, VPN and SMB
Posted: Mon Apr 20, 2020 8:55 pm
by driessen
Thanks a lot, Antonio.
First thing in the morning is testing.
Keep sound and safe.
Re: FWH, VPN and SMB
Posted: Mon Apr 20, 2020 9:01 pm
by driessen
Antonio,
Can you tell me where I can find ads.ch?
Or can you send it to me?
Thanks.
Re: FWH, VPN and SMB
Posted: Mon Apr 20, 2020 10:13 pm
by Antonio Linares
Re: FWH, VPN and SMB
Posted: Tue Apr 21, 2020 1:43 am
by TimStone
I'm sorry ... I was distracted away from the computer today. I would have given you the full implementation. If your trial works out, I will post the code that allows you to set the configuration to use CDX or ADS.
Also, remember to include the proper RDD libraries in your build.
If you have any problems email me: tim at gtstone period com. I will get it right away and respond immediately. Otherwise I won't see it until later since I will be outside building a custom door.
I should add that ADS also has a direct internet connection available so a VPN is not needed. It does, however, require a static IP on the web.
Finally, you do not need to change ANY of your other code. It works just like you have it, and it doesn't matter if it's the old USE commands, or some form of database objects. It should all work.
Tim
Re: FWH, VPN and SMB
Posted: Tue Apr 21, 2020 6:02 am
by driessen
Waaw, thanks a lot Tim.
I will mail you my questions if any.
Have a nice day.