Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Ken Murphy
 To: rose cruz
  Where is rose cruz?
 rose cruz
Subject: RE: EXE...
Thread ID: 143498 Message ID: 143530 # Views: 3 # Ratings: 0
Version: Visual FoxPro 7 Category: .NET
Date: Wednesday, August 29, 2007 3:42:33 PM         

> How can i execute .exe to my server pc while im using my own pc using Foxpro??? My PC is WindowsXP and my server is WindowsNT.
> Is there a code or a class i can use to do this job???
> Thanks...


Not really sure what you are looking for but, it sounds like you are installing your first multi user app on a server and you need a bit of background info.

Lets look at the most common scenario - the EXE is on the workstation and the database (and all of the tables in it) are in a shared directory on the server. You begin by installing the EXE and the VFP runtime libraries (and any other DLL's that you may be using in your application) on the workstation. You can use Inno setup to do this for you (a free downloadable installer program) or you can use InstallShield Express (ships with VFP.) I cannot exactly recall when VFP got rid of the distribution wizard, but if VFP 7 still has it, you can use that. This will place the EXE file on the workstation and do the necessary registration to ensure that the workstation knows how to run your EXE.

On the server, you create a shared directory (talk to your SysAdmin about creating a server share or look it up on the Win NT documentation.) You will also have to set permissions on that share so that your user will have access to it. Again talk to your SysAdmin or look it up in NT help. Once the share is created, you copy your database and all of the files associated with it (tables, indexes etc.) to that share.

Your application will need to know how to find that database. DO NOT HARD CODE THE LOCATION OF THE DATABASE IN YOUR APP. You can use a local table, or an INI file etc. to store the location of the database. You can then issue a SET DEFAULT TO ( lcPath2MyDataBase ) and your application will know how to find it.

Hope this helps.

You shall know the truth - and the truth shall set you free. (John 8:33)


EXE... Posted by rose cruz @ 8/29/2007 11:10:28 AM
RE: EXE... Posted by Ken Murphy @ 8/29/2007 3:42:33 PM
RE: EXE... Posted by rose cruz @ 8/30/2007 2:34:47 AM
RE: EXE... Posted by Ken Murphy @ 8/30/2007 2:59:13 AM
RE: EXE... Posted by rose cruz @ 8/30/2007 3:33:48 AM
RE: EXE... Posted by Ken Murphy @ 8/30/2007 4:44:05 AM
RE: EXE... Posted by rose cruz @ 9/3/2007 6:11:12 AM
RE: EXE... Posted by Ken Murphy @ 9/3/2007 2:55:35 PM
RE: EXE... Posted by Bernard Bout @ 8/30/2007 6:09:29 AM