Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tabletuner
Creator III
Creator 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
Partner - Specialist II
Partner - Specialist II

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
Creator III
Creator III
Author

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