how can I query a dbf file in C#

Posted on 2009-04-27
Medium Priority
Last Modified: 2013-12-17
I'm trying to query a dbf file from a C# ASP.net 3.5 application using ODBC.  The dbf file is part of an event's pro database but I am struggling to get assistance from the original software vendor.  However, I know which file has the required data and can see the records I want using the free application DBF View (www.dbfview.com) which agree perfectly with Event's Pro.  However when I use the Microsoft FoxPro Dirver for dbf files (version 6.01.8629.01 - dll VFPODBC.dll) it will only connect using free table directory mode and lists totally different data.  Where DBF View gives me dozens of fields the ODBC connection only lists two fields.

I would like to know which is the correct way to connect to dbf files and if there is any reference on the structure of this form of database.  When I look on the disk I see three files and I have a suspicion that the FoxPro driver I am using is not viewing all of these.
Question by:RobYoungManchester
LVL 14

Accepted Solution

tusharkanvinde earned 2000 total points
ID: 24240903
Use the VFP OLE DB driver instead of the VFP ODBC driver http://www.microsoft.com/downloads/details.aspx?familyid=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en. The ODBC driver corresponds to VFP 6 and is not compatible with the latest database structure.

Author Comment

ID: 24241827
Thanks - that worked perfectly.

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Suggested Courses
Course of the Month15 days, 3 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question