Hi John
I did have cause to use the DBI::ODBC driver about eight years ago. To connect to the database I used something similar to: $user = ""; $password = ""; $dsno2 = "driver=Microsoft Visual FoxPro Driver;SourceDB=C:\\<path>\\Comp_A.dbc;SourceType=DBC;Exclusive=No"; unless ($do = DBI->connect("dbi:ODBC:$dsno2",$user,$password, { odbc_cursortype => 2, ChopBlanks => true, LongReadLen => 65536, LongTruncOk => 0 })) { print "Content-type: text/html\n\n"; print "Error: couldn't connect to database..." . $DBI::errstr . "<br>\n"; print "(Another user may have exclusive access to the database)<br>\n"; exit; } It did not work very well for me because the database I was connecting to needed to be VFP6 and there was a known problem with the driver for that VFP version... although I believe the VFP9 driver worked correctly. This was a long time ago but I hope it helps. Regards Phil Brewer From: activeperl-boun...@listserv.activestate.com [mailto:activeperl-boun...@listserv.activestate.com] On Behalf Of John DePasquale Sent: 19 September 2015 06:13 To: activeperl@listserv.ActiveState.com Subject: reading vfp dbf files Hi all, I'm trying to track down a database driver for perl that I can use to open and read dbf files created by visual foxpro. I have a lot of experience opening/reading dbf files created by dbase/foxpro, but this is the first time I've tried opening/reading dbfs created by VFP, and those files have a different format so XBASE drivers won't open them. I've done a lot of looking around for a VFP driver for perl but am surprised to find it quite elusive. Do you know if there is a database driver for perl for VFP-created dbf files? Thank you. - john John DePasquale Chief Executive Officer Paradigm Consulting "Proudly presenting the Vinopedia System" www.vinopedia.us <http://www.vinopedia.us/> 49 Dalby Street Newton, MA 02458 Mobile: 617-610-2424 Fax: 617-600-7326 _____ --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
_______________________________________________ ActivePerl mailing list ActivePerl@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs