RE: reading vfp dbf files

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: acti...@listserv.ActiveState.com
[mailto:acti...@listserv.ActiveState.com] On Behalf Of John
DePasquale
Sent: 19 September 2015 06:13
To: acti...@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