Odbc Driver For Dbf Files

Active2 years, 7 months ago
  1. Dbf File Format
  2. Odbc Driver For Dbf Files Windows 7

I am having a lot of trouble using .dbf files. I have an application written in C# that reads from .DBF files and then exports them to another database. I've tried using the Microsoft dBase driver but it's not reading all of the .DBF files that I need to, meaning that I can retrieve data from only two of the five .DBF files, Visual Studio is telling me the other .DBF files don't exist and it keeps saying the my input string is too large. There are some Microsoft Visual Fox Pro drivers but every time I choose one of those, Visual Studio is telling me that it couldn't make a connection. The worst part is that this application will be used on client machines that I don't have access to. How do I keep the ODBC data source so that my application will work on other peoples machine? I am very unfamiliar with .DBFs, have no idea what driver works best, and need someone to walk me through the steps.

View dbf filejumbojsjumbojs
1,9698 gold badges32 silver badges48 bronze badges

SQLDriverConnect enables you to connect to a driver without creating a data source (DSN). The following keywords are supported in the connection string for all drivers: DSN, DBQ, and FIL. When the Paradox driver is used, after a password-protected file has been opened by a user, other users are not allowed to open the same file. Jun 18, 2012  Look for DBF files connection strings for Jet engine and try either Microsoft.ACE.OLEDB.14.0 or Microsoft.ACE.OLEDB.12.0 provider (or driver). Proposed as answer by billb08 - MSFT Tuesday, September 14, 2010 2:55 PM.

Feb 20, 2017  Are these DBF files produced by Foxpro, perchance? If they've been created by a version of Foxpro greater than 7 hten the ODBC driver won't read them anyway. In that case, use the OLE-DB driver instead - which may work with your files whatever their source, worth a try as using OLE-DB gets away from the ODBC data source fiasco. Edit: removed.

Dbf File Format

1 Answer

Are these DBF files produced by Foxpro, perchance? If they've been created by a version of Foxpro greater than 7 hten the ODBC driver won't read them anyway. In that case, use the OLE-DB driver instead - which may work with your files whatever their source, worth a try as using OLE-DB gets away from the ODBC data source fiasco.

Edit: removed spam link

stuartdstuartd
54.4k12 gold badges106 silver badges133 bronze badges

Odbc Driver For Dbf Files Windows 7

Not the answer you're looking for? Browse other questions tagged c#odbcdbf or ask your own question.