FWH, VPN and SMB

[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

[driessen]

Tim,
Thanks a lot for your advice.
I start trying it out immediately.

[driessen]

Tim,

I just installed the evaluation version of ADS 12.0.

I use this code to select RDDCDX

Code: Select all  Expand view  RUN

REQUEST DBFCDX
RDDSETDEFAULT("DBFCDX")

To what do I have to change my code?

But how about converting the existing files?
Thanks.

[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

[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.

[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

[driessen]

Otto,

Thanks a lot for the tip.
Didn't know that.

[Antonio Linares]

Michel,

This is a very basic ads.prg example that is included with mod_harbour:

Code: Select all  Expand view  RUN

#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

[driessen]

Thanks a lot, Antonio.
First thing in the morning is testing.

Keep sound and safe.

[driessen]

Antonio,

Can you tell me where I can find ads.ch?
Or can you send it to me?

Thanks.

[Antonio Linares]

Michel,

Here you have it:

https://github.com/harbour/core/blob/master/contrib/rddads/ads.ch

[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

[driessen]

Waaw, thanks a lot Tim.
I will mail you my questions if any.
Have a nice day.