updated docs

Coordinator
Mar 28, 2011 at 5:30 PM
Edited Mar 28, 2011 at 5:44 PM

I updated the official ActiveVFP documentation(http://thetechconsult.com/demo/html/docs.htm) with 'Installing on your own IIS web server' and 'Centralizing VFP Code':

Centralizing Foxpro code for re-use:
For programs/functions in development you can use ExecScript in addition to scripts in the HTML and main.prg.  For example,

lcRetVal = EXECSCRIPT(FILETOSTR(oProp.AppStartPath+'\prg\myexternalfunc.prg'))

Alternatively, put your code in a seperate HTML file enclosed in <% %> and use the 'include' functionality.  For example, <%= include('myVFPcode.htm') %>

Code used in this way is not locked by IIS so it can be changed at will without recycling IIS.

VFP code that is solid and won't change often can use the traditional ways: SET PROC TO, CREATEOBJECT, etc  (see examples).  This code will be cached by IIS.

Coordinator
Mar 28, 2011 at 10:16 PM

Claude,

Is the Networking part still applicable on this release?  Specificall the COM+ part?

Networked DBFs and SQL setup:

To access dbf data across the network (not on the local machine) or to use SQL Server, MySQL or other backend, you must use Impersonation of an account that has the proper rights to the network data.  The preferred way to do this is to configure IIS Application Pools in IIS 6 and above.

Alternatively , COM + could be used for the same purpose:

1.) go into Control Panel, Component Services
2.) right click COM+ applications and select New.
3.) going through the wizard, create an Empty Application, giving it a name, check server application, and select the appropriate account to run under.
4.) After the Empty Application is created, right click on 'Components' under the newly created application.
5.) select New/Component.
6.) The wizard starts - select 'Import components that are already registered.'
7.) select your Visual FoxPro mtdll from the list and it is added to this COM+ app.
8.) right click on your COM+ application name and select 'Start'. The COM+ icon is now revolving in the Components pane.

Coordinator
Mar 28, 2011 at 10:40 PM

COM+ as an alternative only if IIS Application Pool impersonation is not available.  Nothing should have changed in that regard.