From: Ken Murphy
To: rose cruz
Visual FoxPro 7
Wednesday, August 29, 2007 3:42:33 PM
This message was rated by:
> 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???
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)
Posted by rose cruz @ 8/29/2007 11:10:28 AM
Posted by Ken Murphy @ 8/29/2007 3:42:33 PM
Posted by rose cruz @ 8/30/2007 2:34:47 AM
Posted by Ken Murphy @ 8/30/2007 2:59:13 AM
Posted by rose cruz @ 8/30/2007 3:33:48 AM
Posted by Ken Murphy @ 8/30/2007 4:44:05 AM
Posted by rose cruz @ 9/3/2007 6:11:12 AM
Posted by Ken Murphy @ 9/3/2007 2:55:35 PM
Posted by Bernard Bout @ 8/30/2007 6:09:29 AM