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 _______________________________________________ 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.
