IIs install

[Richard Hane]

Chris,

First thanks for the info.  As you can see I am also copying this to the fp list for further input because frankly I am confused.

When using fpWeb on Apache I don't have to do anything with any of the tables.  All I have to do is load the executible batch files and a few other files (ie. HTMLs) to a specific folder from where they are 'called'.

I do not understand why IIs would be so different than Apache.  Maybe I don't understand what you are saying.

Anyone else want to chime in?

Thank you,
Rick Hane


________________________________
From: Christopher Yerry <christopheryerry at yahoo.com>
To: Richard Hane <yoresoft at sbcglobal.net>
Sent: Mon, March 1, 2010 1:27:42 PM
Subject: Re: IIs install


There are two answers, im giving you both. I will post the second more filePro friendly answer on the usergroup

To do this properly you need to have the filepro datatables accessible from the iis server. they have no security on the tables so they need to be accessable to the server not the outside world
i.e.
   \filePro\TableStructure\Table1
   \filePro\TableStructure\Table2
   \filePro\TableStructure\Table3
etc

in the root of the iis server you need to create a web service. 
    That service is reachable to the outside world, and has has security
i.e.
   http:\\FileproWebservice_TheStitcherCompany.com     or (whatever else you want to call  it)
        You need to write code to read a map file (not hard)
        You will need to include non record locking writing (also not hard)
        You need to understand what makes a filePro record (20bites header plus the record structure)
Have your webpage call the webservice for data

Simpler way (but would have to be completely re written each time)
    Write an asp.net program to create the webpages. include the structure of each table you wish to access and open the file to read and open the file to write. 
You could stay filepro compliant if you wrote to a Non filepro table and then did updates and re indexes periodically throughout the day.

I did create a program one to actually use the filepro indexes but it was a nightmare,

Reading and writing and adding records to a filepro table from outside filepro makes most of the user group nervous, I will post the second answer on the web not the first suggestion. One of these days I need to write the first, just not sure there is a market for it 


 Feel free to call 


Christopher Yerry
CMYerry&Sons
227 Pine ST
Hudson, WI 54016715 410 4904 
10 Years of filePro
20 Years Microsoft (VB 2 - 6, VB.Net, ASP.Net, C#)




________________________________
From: Richard Hane <yoresoft at sbcglobal.net>
To: Christopher Yerry <christopheryerry at yahoo.com>
Cc: Rick Hane <rhane at deluxestitcher.com>
Sent: Mon, March 1, 2010 12:58:23 PM
Subject: Fw: IIs install


Chris,

I don't know if you received my reply (below) or saw John Esak's reply that he would have no problem with you sending it to the filepro list.

I am very interested.

Thanks in advance 
Rick Hane

 


----- Forwarded Message ----
From: Richard Hane <yoresoft at sbcglobal.net>
To: Christopher Yerry <christopheryerry at yahoo.com>
Sent: Fri, February 26, 2010 1:21:25 PM
Subject: Re:


Christopher,

Thanks for replying.

I would like to hear any suggestions you may have.  Also, any problems you may know about.

What I am doing is porting over my plant scheduling and job costing software to be able to run over html screens.  1 reason is to give remote access but that is minor as there are many other ways to do that.  Rather to make better use of charts (gant, flow etc) I need the use of a true gui platform.

I own Howie's fpWeb and like it but I don't want to use Apache as my web server.

For my initial programming and testing I will be installing IIs on my laptop with Vista and using fpODBC version 5.0.15.

Any help would be appreciated but my main question is where do I load the executable programs and batch files for fp?

Thanks again 
Rick Hane

 



________________________________
From: Christopher Yerry <christopheryerry at yahoo.com>
To: filepro-list at lists.celestial.com
Cc: yoresoft at sbcglobal.net
Sent: Fri, February 26, 2010 12:51:15 PM
Subject: 


From: Richard Hane <yoresoft at sbcglobal.net>
Subject: fp running on IIs
To: filepro-list at lists.celestial.com
Message-ID: <520376.7982.qm at web81405.mail.mud.yahoo.com>
Content-Type: text/plain; charset="us-ascii"

To any of you who run filepro apps over the web while using Microsoft's IIs.... 
 

Yes I have done several solutions over the years, I'm not sure if you want the long solution here or offline. Would be happy to do it here if anyone else is interested

Christopher Yerry
CMYerry&Sons
227 Pine ST
Hudson, WI 54016
715 410 4904
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20100301/b758cf0a/attachment.html