VPN on the fly

[Richard Kaye]

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.

TIA

--

rk



--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---

_______________________________________________
Post Messages to: ***@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/***@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.

[Paul Hill]

Post by Richard Kaye
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: ***@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-***@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.

[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-***@leafe.com] On Behalf Of Paul Hill
Sent: Thursday, February 22, 2018 1:48 PM
To: ***@leafe.com
Subject: Re: VPN on the fly

Post by Richard Kaye
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: ***@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/***@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.