I may be muddying the waters, but we've been testing PHP and
MySQL on some of our Windows 2003 servers with standard
IIS, not Apache, and so far I'm impressed with how easy it was
to get everything setup and working.
We did run into problems with PHP 5.x and MySQL 5.x, but
PHP 4.4 and MySQL 4.19 installed and were working within
5-10 minutes.
I also ran across a PHP library product called FormFields Library.
The company has an online FormGen application or you can buy
a local copy of their FormGen product that works with the library.
It makes creating forms and dynamic pages with PHP fairly easy.
The FormFields library has built-in field types and validation for
fields like Credit Card Numbers, CC Dates and a host of others
that come in handy for building online forms.
They're located at www.formfields.com . We're also testing a
product to integrate with MySQL called SQLyog that provides
a pretty decent GUI.
We've done a lot of WebConnect stuff and will probably keep
on using it because so far I think it scales better than PHP.
Maybe somone can explain to me why you would want to
install and use Apache for widnows instead of using IIS while
we're on this subject.
Jim Eddins
I agree with all that. However, my application is pure vfp and works well.
This request for web access is really not related in
any way to my app. I should have said what I was trying to do. I have a
accounts receivable package. I want users with paid monthly
support to be able to download an update over the web with no support
help. I know there are a lot of ways to do this and I have a
method that I have been using for years. The problem: Sometimes they want
to download and can't because they have not paid. So they
pay by credit card but still cannot download because the file that keeps
the information (a text file read by perl) needs to be
manually updated which involved running a report that writes the text
file. We do this monthly. So, if there was a way to read our
data files directly, it would avoid the manual step. Hope that is clear.
In other words, all I need is a way to validate a web
request for download and the information needed is now in vfp native
tables. I could probably update a postgre table when a payment
is made if that makes it work.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "ProFox Email List" <[email protected]>
Sent: Monday, July 17, 2006 12:05 PM
Subject: RE: Need suggestions for Win/apache2 access to native fox data
vfp9
From: "Ken McGinnis" <[EMAIL PROTECTED]>
On Win2000 pro, you can selet Administrative tools, Data Sources (ODBC),
'add' - and close to the bottom there is a selection
for
Microsoft Visual Foxpro Driver - then in the setup dialog there is a
selection: 'Database type' - one of the selections is Visual
FoxPro database (DBC). - wouldn't this work ok?
No it won't. You would also want to avoid ODBC and upgrade to OLEDB.
But back to the initial Q. You don't have the workstation mentality
that makes VFP as good as it is. You have a server taking web requests
via PHP, correct? Why not work with a data access that is in line with
your other tools? VFP doesn't fit into this environment well as
compared to MySQL.
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
