ok, so maybe I could update a Postgres with the values (instead of creating a fox free table), then perl could read and write the Postgres data. What if I only want to read/write 4 fields (maybe 20,000 records) into a single table? Do you know a URL reference for
1. install Postgres on Win2000 pro 2. some simple code for vfp9 to read/write 4 fields in Postgres 3. some simple perl code to read/write the same fields in Postgres Sry if this is something simple, but I have no experience with Postgres. Thanks ----- Original Message ----- From: "Ted Roche" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, July 17, 2006 11:07 AM Subject: Re: Need suggestions for Win/apache2 access to native fox data vfp9 On 7/17/06, Ken McGinnis <[EMAIL PROTECTED]> wrote: > 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? Yes, I'm quite familar with using VFP via ODBC. However, I don't think that's what the vast majority of people use when they are running Perl-based web sites. As a consequence, you're more likely going to run into challenges getting support. You seemed to indicate that your eighteen years of FoxPro experience would serve you better than your newly-acquired Perl skills, so I recommend using FoxPro to read and write to the popular MySQL (or Postgres) format, rather than depend on the more obscure ODBC or OLEDB of Perl/W32. I think you'd find more support and better-tested code that way. Maybe not. If you want Perl to use ODBC, bear in mind you're limited to VFP 6 versions of the database. > > The other option is 'Free Table directory". > It would be easy for me to create a free table with updated values > periodically if perl could access it. (would be nice if perl > could write to it also) > Perl can read and write DBFs. Look for XBase in: http://www.perl.com/CPAN/authors/Jan_Pazdziora/ I suspect that reads and writes DBFs directly, which may be undesirable. It's also dated 2003 which either means it's bug-free or abandoned. On the good side, it may be solid. On the down, it likely doesn't support any features later than 2003. Instead, if you want to try ODBC, take a look at: http://www.roth.net/perl/odbc/ So, there's certainly a lot of options to consider. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [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.
