Link to home
Start Free TrialLog in
Avatar of RobYoungManchester
RobYoungManchester

asked on

how can I query a dbf file in C#

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.
ASKER CERTIFIED SOLUTION
Avatar of tusharkanvinde
tusharkanvinde
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RobYoungManchester
RobYoungManchester

ASKER

Thanks - that worked perfectly.