I did a perl application that worked with a VFP database years ago, and
decided that perl was much better suited to a database like PostgreSQL
or MySQL. Microsoft abandoned ODBC in favor of OLE DB around VFP 6,
even though ODBC was the industrial standard at the time and used by all
major vendor including Oracle, DB2, Informix, PostgreSQL, etc.
The Perl DBI can be used to connect to VFP using ODBC, but to my
knowledge, there is no perl DBI OLE DB provider that can be used with
VFP. This means that many of VFP best features, that came after VFP 6,
like all the DBC procedures, including RI and auto-increment, will
fail. Also, VFP uses a fixed length record, and perl is very sensitive
to all character in a string, including spaces, so you will have to
strip out space characters to change VFP fixed length records into
variable length records when doing comparisons, for example.
If you would like to take a look at the example app that uses perl to
connect to VFP, visit my web site and go into the shopping cart
application. The shopping cart application will allow you to download
perl2vfp.ZIP. You will need to register to get to the downloads, but
the perl2vfp.ZIP is a free. Incidentially, the shopping cart
application is written in perl, but connects to a postgreSQL database
server. You can download the smcart-0.96-i386.tar.gz file to take a
look at the source code of the shopping cart application to see how perl
can be used with a PostgreSQL database server. The shopping cart
application if free, unless it is put into production. If the shopping
cart application is used in production, I ask the user to make a nominal
payment for a license.
http://www.smvfp.com
http://www.smvfp.com/index16.html
I am currently working on a perl application, using the same framework
that drives the shopping cart application, to write an application that
allow the esay administration of the sasldb authentication database for
a cyrus-imapd email system. The application allows remote and local end
users to change their password for accessing the email server. It also
allows the system admin to easily select, add, update, and delete end
users/passwords.
Regards,
LelandJ
Ken McGinnis wrote:
I have Windows running Apache2.2/Perl 5.8. I have httpd.conf and extra\httpd-vhosts.conf setup so I can use named virtual hosts
with the same IP - presently hosting 12 domains on one computer with plans to expand to many more.
I have a web page with a form that captures an ID & Psw and passes them to a perl script that looks up the id/psw in a text file
and if there, checks the same id against a 'used' text file with ids that have already been used, if not there, I allow it to be
used and put the id in the 'used' file. etc.etc.
I would like to look this stuff up in a Fox database and interact with a vfp9 program running on the same machine as I am a good
fox programmer (since 1988), but a beginner with perl and it is frustrating to get anything done.
There was a recent thread about west wind some a couple of others. I tried to research those but ran out of time. I am looking for
something quick to get me going and I can expand it in the future.
I am looking for suggestions.
[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.
