Index
2003-10-12 01:13 – Brian Abbott : RE: VFP and VPN
2003-10-12 01:36 – =?iso-8859-1?Q?Fabiano_Ara=FAjo?= : VFP and VPN
2003-10-12 12:29 – Gilbert M. Hale : RE: VFP and VPN
2003-10-13 05:31 – Andy Davies : RE: VFP and VPN
2003-10-13 05:44 – Brian Abbott : RE: VFP and VPN
2003-10-13 08:42 – Derek J. Kalweit : RE: VFP and VPN
2003-10-26 12:48 – =?iso-8859-1?Q?Fabiano_Ara=FAjo?= : Re: VFP and VPN
2003-10-27 06:27 – Pragma epost : Re: VFP and VPN
2014-04-05 03:04 – Allen : VFP and VPN
2014-04-05 04:22 – Paul Hill : Re: VFP and VPN
Back to top
RE: VFP and VPN

Author: Brian Abbott

Posted: 2003-10-12 01:13:00   Link

Fabiano

A VPN on its own doesn't give you enough bandwidth to run VFP. But what =

you

can do, having got your VPN working, is to use Windows Terminal Services =

or

Citrix Metaframe or VNC (www.realvnc.com) or pcAnywhere to run VFP =

remotely

inside the VPN. Any of these options work very well.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Brian Abbott

ACA Systems

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20

> -----Original Message-----

> From: profox-bounces@leafe.com=20

> [mailto:profox-bounces@leafe.com] On Behalf Of Fabiano Ara=FAjo

> Sent: Sunday, October 12, 2003 5:33 AM

> To: profox@leafe.com

> Subject: VFP and VPN

>=20

>=20

> Can I connect my pc in VPN (Virtual Private Network) using my=20

> VFP application =BF

>=20

> Please contact me !

>=20

> Thank you !

>=20

> Fabiano Ara=FAjo

>=20

>=20

>=20

[excessive quoting removed by server]

©2003 Brian Abbott
Back to top
VFP and VPN

Author: =?iso-8859-1?Q?Fabiano_Ara=FAjo?=

Posted: 2003-10-12 01:36:00   Link

Can I connect my pc in VPN (Virtual Private Network) using my VFP

application ¿

Please contact me !

Thank you !

Fabiano Araújo

©2003 =?iso-8859-1?Q?Fabiano_Ara=FAjo?=
Back to top
RE: VFP and VPN

Author: Gilbert M. Hale

Posted: 2003-10-12 12:29:00   Link

Fabiano,

I agree with Brian re: how to run a VFP app over a low bandwidth connection

if you are using VFP in a traditional manner where one or more tables are

being opened and used directly. I have found Windows Terminal Services to

be a fine solution, provided you do not require a table to be used

exclusively, such as using a table on a local PC exclusively to prevent a

2nd instance from running on that local machine. The reason is that the

"local machine" is actually a shared machine (due to the way Terminal

Services Server works), so a table on Drive C: that is used exclusively to

prevent an app from running a 2nd instance in a conventional network File

Server environment is actually being opened exclusively on the Terminal

Services PC on what is effectively a shared resource. So the 2nd person who

will try to run the app via Terminal Services will try to open the "control

table" exclusively a second time on the Terminal Services PC and the app

will fail.

The way I "got around" this matter without having to support 2 sets of apps

for the same product (named "DCMS"), one for LAN and one for Terminal

Services, is by using the VFP OS() function as in the following code

snippet:

&&-----------------------

LOCAL mOSVersionTerminalServices, mOSVersion2000Server, mLocalDCMSNotInUse

mOSVersionTerminalServices = VAL(OS(10)) &&Terminal Services Installed

mOSVersion2000Server = VAL(OS(11)) &&Using Windows 2000 Domain Controller

Server/Server

OPEN DATABASE AppDBCLocalDCMS SHARED

IF (BETWEEN(mOSVersionTerminalServices, 16, 24) OR ;

BETWEEN(mOSVersionTerminalServices, 48, 54)) AND ;

mOSVersion2000Server >= 2

mLocalDCMSNotInUse = .F.

ON ERROR mLocalDCMSNotInUse = .T.

SELECT LoggedOn

ON ERROR

IF mLocalDCMSNotInUse = .T.

USE AppDBCLocalDCMS!LoggedOn IN 0 SHARED

ENDIF

ELSE

ON ERROR QUIT &&Simple Way To Prevent > 1 Instance Of DCMS From Running

USE AppDBCLocalDCMS!LoggedOn IN 0 EXCLUSIVE

ON ERROR

ENDIF

&&-----------------------

I use pcAnywhere and VNC over VPN connections with client locations ranging

from Puerto Rico to California with excellent results, but that is a method

of providing remote support. I have not found it to be a practical way to

deploy an app over a thin-net connection.

If you were to convert the VFP app to use SQL Pass Through cursors instead

of traditional VFP tables, and get the record selection criteria set up to

not retrieve huge data sets (SQL Select "TOP nnn"), you will find this an

effective way to get VFP to run across a thin-net connection. Recently an

associate and I have opted to use VFP on the front end to build an app using

MySQL on the back end. Through his excellent SQL Pass Through techniques my

associate has gained excellent performance over an Internet connection

(cable modems at each end). The use of MySQL was driven by the need to

allow table sizes > 2Gb, but the thin-net SQL Pass Through performance was a

factor in deciding to use SQL Pass Through whether it would have been MySQL,

VFP or some other vendor's tables on the Server.

Good Luck!

Gil

Gilbert M. Hale

New Freedom Data Resources

Pittsford, NY

585-359-8085

gil@gilhale.com

> -----Original Message-----

> From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com]On

> Behalf Of Brian Abbott

> Sent: Sunday, October 12, 2003 2:04 AM

> To: 'ProFox Email List'

> Subject: RE: VFP and VPN

>

>

> Fabiano

>

> A VPN on its own doesn't give you enough bandwidth to run VFP.

> But what you

> can do, having got your VPN working, is to use Windows Terminal

> Services or

> Citrix Metaframe or VNC (www.realvnc.com) or pcAnywhere to run

> VFP remotely

> inside the VPN. Any of these options work very well.

>

> ============

> Brian Abbott

>

> ACA Systems

> ============

>

> > -----Original Message-----

> > From: profox-bounces@leafe.com

> > [mailto:profox-bounces@leafe.com] On Behalf Of Fabiano Araújo

> > Sent: Sunday, October 12, 2003 5:33 AM

> > To: profox@leafe.com

> > Subject: VFP and VPN

> >

> >

> > Can I connect my pc in VPN (Virtual Private Network) using my

> > VFP application ¿

> >

> > Please contact me !

> >

> > Thank you !

> >

> > Fabiano Araújo

> >

> >

> >

[excessive quoting removed by server]

©2003 Gilbert M. Hale
Back to top
RE: VFP and VPN

Author: Andy Davies

Posted: 2003-10-13 05:31:00   Link

Brian Abbot said "A VPN on its own doesn't give you enough bandwidth to run

VFP."

Brian, are you just talking about data / index suck? - i.e. would

client/server VFP run OK (vfp front end to e.g. Oracle).

AndyD 8-)#

©2003 Andy Davies
Back to top
RE: VFP and VPN

Author: Brian Abbott

Posted: 2003-10-13 05:44:00   Link

Yeah, I was assuming it was against .dbfs ...

============

Brian Abbott

ACA Systems

============

> -----Original Message-----

> From: profox-bounces@leafe.com

> [mailto:profox-bounces@leafe.com] On Behalf Of Andy Davies

> Sent: Monday, October 13, 2003 11:09 AM

> To: ProFox Email List

> Subject: RE: VFP and VPN

>

>

>

> Brian Abbot said "A VPN on its own doesn't give you enough

> bandwidth to run VFP."

>

> Brian, are you just talking about data / index suck? - i.e.

> would client/server VFP run OK (vfp front end to e.g. Oracle).

>

> AndyD 8-)#

>

>

>

>

>

> **********************************************************************

> This email and any files transmitted with it are confidential

> and intended solely for the use of the individual or entity

> to whom they are addressed. If you have received this email

> in error please notify the system manager.

>

> This footnote also confirms that this email message has been swept

> for the presence of computer viruses.

>

> Please contact internet.administrators@notes.manchester.gov.uk

> with any queries.

>

>

[excessive quoting removed by server]

©2003 Brian Abbott
Back to top
RE: VFP and VPN

Author: Derek J. Kalweit

Posted: 2003-10-13 08:42:00   Link

> Brian Abbot said "A VPN on its own doesn't give you enough=20

> bandwidth to run VFP."

> Brian, are you just talking about data / index suck? - i.e. would

> client/server VFP run OK (vfp front end to e.g. Oracle).

As long as data sets/communication is kept as small as possible, and the =

executable is local, a VFP app connecting to a real RDBMS can perform =

quite well over a low-bandwidth connection such as a VPN. I have such a =

setup running here with MSSQL, and the performance is very usable...

--=20

Derek

©2003 Derek J. Kalweit
Back to top
Re: VFP and VPN

Author: =?iso-8859-1?Q?Fabiano_Ara=FAjo?=

Posted: 2003-10-26 12:48:00   Link

Can I print my RTF Document (RichText) in RichText control in my VFP

aplication ¿

How ¿

Thanx,

Fabiano Araújo

©2003 =?iso-8859-1?Q?Fabiano_Ara=FAjo?=
Back to top
Re: VFP and VPN

Author: Pragma epost

Posted: 2003-10-27 06:27:00   Link

Fabiano

DECLARE INTEGER CreateDC IN Win32Api STRING, STRING, INTEGER, INTEGER

DECLARE INTEGER DeleteDC IN Win32Api INTEGER

cPrinter = Set("PRINTER",3)

hDC = CreateDC("WINSPOOL",cPrinter,0,0)

ThisForm.axRTF.SelPrint(hDC)

DeleteDC(hDC)

-Anders

----- Original Message -----

From: "Fabiano Araújo" <allanbique@ig.com.br>

To: <profox@leafe.com>

Sent: Sunday, October 26, 2003 6:48 PM

Subject: Re: VFP and VPN

> Can I print my RTF Document (RichText) in RichText control in my VFP

> aplication ¿

>

> How ¿

>

> Thanx,

>

> Fabiano Araújo

>

>

>

[excessive quoting removed by server]

©2003 Pragma epost
Back to top
VFP and VPN

Author: Allen

Posted: 2014-04-05 03:04:49   Link

Hi Foxgang

Up to now I have used the FTP prg to send data to the FTP server. Now one

client has to VPN to the FTP server. I am not very well up on VPN. Anyway,

is it possible to start a VFP connection prior to FTP in code? My program

does certain reports etc automatically overnight.

TIA

Al

_______________________________________________

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/001c01cf50a5$c3e2f290$4ba8d7b0$@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.

©2014 Allen
Back to top
Re: VFP and VPN

Author: Paul Hill

Posted: 2014-04-05 04:22:26   Link

On 5 April 2014 09:04, Allen <profox@gatwicksoftware.com> wrote:

> Hi Foxgang

> Up to now I have used the FTP prg to send data to the FTP server. Now one

> client has to VPN to the FTP server. I am not very well up on VPN. Anyway,

> is it possible to start a VFP connection prior to FTP in code? My program

> does certain reports etc automatically overnight.

Hi Al,

You can open a VPN from the command prompt:

rasdial myvpn username password

rasdial myvpn /disconnect

If all else fails you can call these from Fox.

--

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++Z2C0X9bexTdWimSZms3ZC5CpNarFyD8hXpEBcqpD0Ag@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.

©2014 Paul Hill