Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 165775 - Last Review: February 24, 2005 - Revision: 1.3
HOWTO: Set up a Visual FoxPro Internet Server
This article was previously published under Q165775
Below are some considerations that need to be addressed before you create a
Web page with Visual FoxPro.
On Windows NT 4.0, check to see if there is a subdirectory called \InetPub.
This folder and its subfolders are necessary if you are setting up the
Windows NT Server as a Web server. If this folder is not present, run
Windows NT CD. This folder should be present if you elected to install
Internet Server capabilities when you installed Windows NT.
- Setup the Internet Server Manager. You can find it by clicking Start
on the Windows NT task bar, selecting Programs, selecting
Microsoft Internet Server (Common), and finally selecting Internet
Server Manager.
- The dialog box that appears shows that three Services are running: WWW,
Gopher, and FTP. Right-click WWW and click "Service Properties."
- On the WWW Service Properties dialog box, click the Directories tab and
highlight \inetpub\wwwroot. Click Edit Properties. The Directory
Properties dialog box appears. Make sure that both the Read and Execute
check boxes are selected. Read is checked by default, but Execute may
not be checked. You may change the directory here, but it is recommended
that you leave \inetpub\wwwroot as the directory when starting out.
NOTE: Information on changing this directory is located in the Product
Documentation HTML file.
- The \inetpub\wwwroot directory contains the default.htm file. Test the
Internet connection to your server by typing //servername/default.htm
from Internet Explorer on another machine. If this works then create
your FoxPro Internet Server by running the Internet Search Wizard or
HOME()+"TOOLS\INETWIZ\WWWPAGE.APP".
Step 1: Select Tables, and then select customer.dbf from the
Visual FoxPro\Samples\Data folder.
Step 2: Click Search Field and select the Cust_id field.
Step 3: Select Set Search Page Options and enter a search page title.
Step 4: With Set Up Search Page add any .gif file.
Step 5: Click Result Fields, and then select the Cust_id, Company,
Address, City, and Country fields.
Step 6: For the Set Up Result Page, add any .gif file and select
"<none> FoxPro Server" for the ODBC data source.
- After you run the Internet Search Wizard, place everything in
\inetpub\wwwroot. The following files created by wwwpage.app should be
in the \inetpub\wwwroot directory:
{Page name}.htm(l)
{Page name}.htx
{Page name}.idc
The following files also need to be in this directory:
Server.app
Vfpcgi.exe
Querylog.dbf and fpt
Vfpis.ini (This file is created when Server.app is run and configured
in step 6.)
The files listed above can be found in the \vfp\tools\inetwiz\server
directory.
- In Visual FoxPro, run the Server.app located in \inetpub\wwwroot.
Click Options and specify the following:
HTTP Server c:\inetpub\wwwroot\
Scripts c:\inetpub\
Path c:\vfp\samples\data
The Path assumes you are querying a table in that directory.
For further information on creating an Internet Server with FoxPro look up
"Internet" in both Help and the online documentation. There is an HTML file
called Product Documentation which can be accessed by clicking Start on the
Windows NT task bar, selecting Programs, and then selecting Microsoft
Internet Server (Common).
APPLIES TO
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 5.0a
- Microsoft Visual FoxPro 6.0 Professional Edition
- Microsoft Data Access Components 2.5
| kbdesigner kbhowto KB165775 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate