<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV>Chris,</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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'.</DIV>
<DIV> </DIV>
<DIV>I do not understand why IIs would be so different than Apache. Maybe I don't understand what you are saying.</DIV>
<DIV> </DIV>
<DIV>Anyone else want to chime in?</DIV>
<DIV> </DIV>
<DIV>Thank you,</DIV>
<DIV>Rick Hane</DIV>
<DIV> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><FONT face=Tahoma size=2>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Christopher Yerry <christopheryerry@yahoo.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Richard Hane <yoresoft@sbcglobal.net><BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Mon, March 1, 2010 1:27:42 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: IIs install<BR></FONT><BR>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: times new roman, new york, times, serif">There are two answers, im giving you both. I will post the second more filePro friendly answer on the usergroup<BR><BR>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<BR>i.e.<BR> \filePro\TableStructure\Table1<BR> \filePro\TableStructure\Table2<BR> \filePro\TableStructure\Table3<BR>etc<BR><BR>in the root of the iis server you need to create a web service. <BR> That service is reachable to the outside world, and has has security<BR>i.e.<BR> http:\\FileproWebservice_TheStitcherCompany.com or (whatever else you want to call it)<BR> You need to write code to read a map file (not
hard)<BR> You will need to include non record locking writing (also not hard)<BR> You need to understand what makes a filePro record (20bites header plus the record structure)<BR>Have your webpage call the webservice for data<BR><BR>Simpler way (but would have to be completely re written each time)<BR> Write an <A href="http://asp.net/" target=_blank>asp.net</A> 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. <BR>You could stay filepro compliant if you wrote to a Non filepro table and then did updates and re indexes periodically throughout the day.<BR><BR>I did create a program one to actually use the filepro indexes but it was a nightmare,<BR><BR>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 <BR><BR>
<DIV> Feel free to call <BR><BR></DIV>
<DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt; COLOR: maroon"><FONT face="Times New Roman" color=#000000 size=1><SPAN style="FONT-SIZE: 7.5pt"><SPAN style="FONT-SIZE: 12pt; COLOR: maroon"><SPAN class=unmark><EM><FONT color=#000000><STRONG>Christopher Yerry</STRONG></FONT></EM></SPAN></SPAN></SPAN></FONT></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" color=maroon size=3><SPAN style="FONT-SIZE: 12pt; COLOR: maroon"><FONT face="Times New Roman" size=1><SPAN style="FONT-SIZE: 7.5pt"><SPAN style="FONT-SIZE: 12pt; COLOR: maroon"><SPAN class=unmark><STRONG>CMY</STRONG><FONT size=2><EM>erry&Sons</EM></FONT></SPAN></SPAN></SPAN></FONT></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" color=maroon size=3></FONT><FONT face="Times New Roman" color=#000000 size=1><SPAN style="FONT-SIZE: 7.5pt">227 Pine ST</SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT color=#000000><FONT face="Times New Roman" size=1><SPAN style="FONT-SIZE: 7.5pt">Hudson</SPAN></FONT><FONT size=1><SPAN style="FONT-SIZE: 7.5pt">, WI 54016</SPAN></FONT></FONT></DIV><SPAN style="FONT-WEIGHT: bold">715 410 4904</SPAN><FONT face="Times New Roman" size=1><SPAN style="FONT-SIZE: 7.5pt"><SPAN style="FONT-SIZE: 12pt; COLOR: maroon"><SPAN class=unmark id=misspell-2><STRONG><FONT size=2><EM></EM></FONT></STRONG></SPAN></SPAN></SPAN></FONT> </DIV>
<DIV>10 Years of filePro<BR>20 Years Microsoft (VB 2 - 6, VB.Net, ASP.Net, C#)<BR></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: times new roman, new york, times, serif"><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><FONT face=Tahoma size=2>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Richard Hane <yoresoft@sbcglobal.net><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Christopher Yerry <christopheryerry@yahoo.com><BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> Rick Hane <rhane@deluxestitcher.com><BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Mon, March 1, 2010 12:58:23 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Fw: IIs install<BR></FONT><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV>Chris,</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>I am very interested.</DIV>
<DIV> </DIV>
<DIV>Thanks in advance </DIV>
<DIV>Rick Hane</DIV>
<DIV><BR> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><FONT face=Tahoma size=2>----- Forwarded Message ----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Richard Hane <yoresoft@sbcglobal.net><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Christopher Yerry <christopheryerry@yahoo.com><BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Fri, February 26, 2010 1:21:25 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re:<BR></FONT><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV>Christopher,</DIV>
<DIV> </DIV>
<DIV>Thanks for replying.</DIV>
<DIV> </DIV>
<DIV>I would like to hear any suggestions you may have. Also, any problems you may know about.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>I own Howie's fpWeb and like it but I don't want to use Apache as my web server.</DIV>
<DIV> </DIV>
<DIV>For my initial programming and testing I will be installing IIs on my laptop with Vista and using fpODBC version 5.0.15.</DIV>
<DIV> </DIV>
<DIV>Any help would be appreciated but my main question is where do I load the executable programs and batch files for fp?</DIV>
<DIV> </DIV>
<DIV>Thanks again </DIV>
<DIV>Rick Hane</DIV>
<DIV><BR> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><FONT face=Tahoma size=2>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Christopher Yerry <christopheryerry@yahoo.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> filepro-list@lists.celestial.com<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> yoresoft@sbcglobal.net<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Fri, February 26, 2010 12:51:15 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> <BR></FONT><BR>
<DIV style="FONT-SIZE: 10pt; COLOR: rgb(67,67,67); FONT-FAMILY: times new roman, new york, times, serif">From: Richard Hane <<A href="mailto:yoresoft@sbcglobal.net" target=_blank rel=nofollow ymailto="mailto:yoresoft@sbcglobal.net">yoresoft@sbcglobal.net</A>><BR>Subject: fp running on IIs<BR>To: <A href="mailto:filepro-list@lists.celestial.com" target=_blank rel=nofollow ymailto="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</A><BR>Message-ID: <<A href="mailto:520376.7982.qm@web81405.mail.mud.yahoo.com" target=_blank rel=nofollow ymailto="mailto:520376.7982.qm@web81405.mail.mud.yahoo.com">520376.7982.qm@web81405.mail.mud.yahoo.com</A>><BR>Content-Type: text/plain; charset="us-ascii"<BR><BR>To any of you who run filepro apps over the web while using Microsoft's IIs....
<DIV> <BR><BR>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<BR></DIV>
<DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt; COLOR: maroon"><FONT face="Times New Roman" color=#000000 size=1><SPAN style="FONT-SIZE: 7.5pt"><SPAN style="FONT-SIZE: 12pt; COLOR: maroon"><SPAN class=unmark><EM><FONT color=#000000><STRONG>Christopher Yerry</STRONG></FONT></EM></SPAN></SPAN></SPAN></FONT></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" color=maroon size=3><SPAN style="FONT-SIZE: 12pt; COLOR: maroon"><FONT face="Times New Roman" size=1><SPAN style="FONT-SIZE: 7.5pt"><SPAN style="FONT-SIZE: 12pt; COLOR: maroon"><SPAN class=unmark><STRONG>CMY</STRONG><FONT size=2><EM>erry&Sons</EM></FONT></SPAN></SPAN></SPAN></FONT></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" color=maroon size=3></FONT><FONT face="Times New Roman" color=#000000 size=1><SPAN style="FONT-SIZE: 7.5pt">227 Pine ST</SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT color=#000000><FONT face="Times New Roman" size=1><SPAN style="FONT-SIZE: 7.5pt">Hudson</SPAN></FONT><FONT size=1><SPAN style="FONT-SIZE: 7.5pt">, WI 54016</SPAN></FONT></FONT></DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" color=#000000 size=1><SPAN style="FONT-SIZE: 7.5pt">715 410 4904<BR></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=1><SPAN style="FONT-SIZE: 7.5pt"></SPAN></FONT> </DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=1><SPAN style="FONT-SIZE: 7.5pt"><SPAN style="FONT-SIZE: 12pt; COLOR: maroon"></SPAN></SPAN></FONT> </DIV></DIV>
<DIV><BR></DIV></DIV><BR></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV><BR></DIV></DIV></div></body></html>