Page 1 of 1
To read Foxpro .DBF files
Posted: Wed Mar 23, 2011 4:30 am
by saugat_1982
I am interested to read foxpro dbf files ( created in Window) to read through DataStage ( in Linux) .
Can you please any one suggest me the steps /prerequisites for this process ?
Thank you .
Posted: Wed Mar 23, 2011 6:33 am
by chulett
ODBC. You (or someone here) will need to check if one of the branded ODBC drivers that ship with the product suport .dbf files, if not one would need to be purchased.
Posted: Wed Mar 23, 2011 1:41 pm
by ray.wurlod
I think the requirement is to read from the DBF files directly, rather than through FoxPro. There are Google articles about how to program this using languages like C# or VB that you may be able to adapt into, say, a DataStage routine.
Posted: Wed Mar 23, 2011 2:11 pm
by chulett
ray.wurlod wrote:I think the requirement is to read from the DBF files directly
I assumed so to, something ODBC should be able to handle quite easily I would think.
Posted: Wed Mar 23, 2011 4:35 pm
by saugat_1982
@ Craig - Requirement is to read from dbf files , no access to Foxpro DB .
So I am not sure, will just an "ODBC" be a solution ?
@ Ray - I beleive 3rd party will definitely able to do , but client is insisting on xploring any feature in IIS can do that or not ?
Thnx
Saugat
Posted: Wed Mar 23, 2011 9:33 pm
by chulett
saugat_1982 wrote:@ Craig - Requirement is to read from dbf files , no access to Foxpro DB .
So I am not sure, will just an "ODBC" be a solution ?
I've said it twice, I guess a third time won't hurt -
Yes. AFAIK, you just need the right ODBC driver.
Posted: Wed Mar 23, 2011 11:12 pm
by jwiles
I bet that if the OP looks in the $DSHOME/.odbc.ini file the correct driver will indeed be found.
Posted: Thu Mar 24, 2011 1:03 am
by ray.wurlod
It's not there. No FoxPro ODBC driver ships with IIS 8.5.
Posted: Thu Mar 24, 2011 1:11 am
by jwiles
Well, bummer. It was there in 8.1, under the guise of dbase.
Posted: Thu Mar 24, 2011 6:53 am
by chulett
Right... look for a "dbase" driver, not anything that specifically says FoxPro.
Posted: Thu Mar 24, 2011 3:48 pm
by jwiles
Yeah, yeah, yeah....
It's the same driver for DBase, FoxPro and a few others which utilize the DBF file format.
dbf drivers
Posted: Thu Sep 20, 2012 7:11 am
by sinhasaurabh014
Apologies for late posting ....
Even though the .odbc.ini file mentions the complete driver name, when i checked in the path, the said driver does not exist.
I am not sure if IBM ships it with the package. Does anybody have any idea?
Code: Select all
[dBase]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdbf25.so
Description=DataDirect dBaseFile(*.dbf) Driver
Posted: Thu Sep 20, 2012 3:33 pm
by ray.wurlod
My understanding is that IBM only ships this one for Windows-based servers (ditto for the SQL Server Connector).