Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
tabletuner
Contributor III

OLEDB Connector Cant open FoxPro DBF

Hi Forum,

My client has a foxpro dbf file called monteurs.dbf.  The file is accompanied with an FPT file.

He updates the file every few days.

QlikView had no problem reading this file with the microsoft visual foxpro OLE DB connector 1.0.0 .

However, after an update of the source system, the DBF file became unreadable for the connector.

I use windows server 2008 and qlikview 11.2.

I also tried several DBF recovery programs but that doesnt help either.

Any one got the same experience or a solution?

Regards,

Tjeerd Wieberdink

2 Replies
flipside
Valued Contributor II

Re: OLEDB Connector Cant open FoxPro DBF

Hi Tjeerd,

I'm not an expert on VFP files but briefly had a project where we loaded data from supplied files out of VFP. I remember some files wouldn't load without the accompanying .cdx file but others would, so am guessing this file contained important structural data. Maybe the update has changed the need (or in your case lack of need) for this file, can you obtain these and see if it loads then?

flipside

tabletuner
Contributor III

Re: OLEDB Connector Cant open FoxPro DBF

Hi Flipside,

I appreciate your answer. However, the solution is to set the TABLEVALIDATE variable in the connector to 0 instead of 3.

I hope others will take advantage of this knowledge.

Regards,

Tjeerd

Community Browser