To read Foxpro .DBF files

saugat_1982 · Post by **saugat_1982** » Wed Mar 23, 2011 4:30 am

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 .

chulett · Post by **chulett** » Wed Mar 23, 2011 6:33 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 23, 2011 1:41 pm

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.

chulett · Post by **chulett** » Wed Mar 23, 2011 2:11 pm

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.

saugat_1982 · Post by **saugat_1982** » Wed Mar 23, 2011 4:35 pm

@ 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

chulett · Post by **chulett** » Wed Mar 23, 2011 9:33 pm

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.

jwiles · Post by **jwiles** » Wed Mar 23, 2011 11:12 pm

I bet that if the OP looks in the $DSHOME/.odbc.ini file the correct driver will indeed be found.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 24, 2011 1:03 am

It's not there. No FoxPro ODBC driver ships with IIS 8.5.

jwiles · Post by **jwiles** » Thu Mar 24, 2011 1:11 am

Well, bummer. It was there in 8.1, under the guise of dbase.

chulett · Post by **chulett** » Thu Mar 24, 2011 6:53 am

Right... look for a "dbase" driver, not anything that specifically says FoxPro.

jwiles · Post by **jwiles** » Thu Mar 24, 2011 3:48 pm

Yeah, yeah, yeah....

It's the same driver for DBase, FoxPro and a few others which utilize the DBF file format.

sinhasaurabh014 · Post by **sinhasaurabh014** » Thu Sep 20, 2012 7:11 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Sep 20, 2012 3:33 pm

My understanding is that IBM only ships this one for Windows-based servers (ditto for the SQL Server Connector).

DSXchange

To read Foxpro .DBF files

To read Foxpro .DBF files

dbf drivers