RE: VPN on the fly

2018-02-22 Thread Richard Kaye
Thanks, Paul. I appreciate the response.

That implies that if a specific VPN client is required, it has to be installed 
first.

--

rk

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Hill
Sent: Thursday, February 22, 2018 1:48 PM
To: profoxt...@leafe.com
Subject: Re: VPN on the fly

On 22 February 2018 at 17:45, Richard Kaye <rk...@invaluable.com> wrote:
> Throwing this out to the wisdom of the crowd. For many, many years we have 
> been doing some data interchange in our VFP application between back office 
> DBs (VFP or SQL) and a centrally located SQL DB via ODBC. The question has 
> been raised about encrypting that traffic by going through a VPN tunnel. I 
> was wondering if anyone here has implemented a VPN on the fly before making 
> ODBC requests. Preferably I could only make this connection when I need it as 
> opposed to firing up a VPN before the application starts as most things done 
> by the program do not require this data interchange.

Depends on your VPN client.

You can open a Windows PPTP VPN by executing a command..
Something like: rasdial "vpn name" username password

The other option is a SSH tunnel.  Probably requires a Linux server at
the other end.
We used to do this in one of our products but last week switched to https.
(or some other IPsec, haven't had a chance to look at it yet).

-- 
Paul

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cy4pr10mb12393d301f056ef5f4117750d2...@cy4pr10mb1239.namprd10.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: VPN on the fly

2018-02-22 Thread Paul Hill
On 22 February 2018 at 17:45, Richard Kaye  wrote:
> Throwing this out to the wisdom of the crowd. For many, many years we have 
> been doing some data interchange in our VFP application between back office 
> DBs (VFP or SQL) and a centrally located SQL DB via ODBC. The question has 
> been raised about encrypting that traffic by going through a VPN tunnel. I 
> was wondering if anyone here has implemented a VPN on the fly before making 
> ODBC requests. Preferably I could only make this connection when I need it as 
> opposed to firing up a VPN before the application starts as most things done 
> by the program do not require this data interchange.

Depends on your VPN client.

You can open a Windows PPTP VPN by executing a command..
Something like: rasdial "vpn name" username password

The other option is a SSH tunnel.  Probably requires a Linux server at
the other end.
We used to do this in one of our products but last week switched to https.
(or some other IPsec, haven't had a chance to look at it yet).

-- 
Paul

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cadwx0+krf695acvjtx6+5advcofh-7hzb03janvwonphbwk...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.