Devart ODBC Driver for xBase is a high-performance connectivity tool with enterprise-level features for accessing FoxPro, Visual FoxPro, dBase, and other databases in DBF file formats from ODBC-compliant reporting, analytics, BI, and ETL tools on 32-bit and 64-bit Windows, macOS, and Linux. Our ODBC driver fully supports standard ODBC API functions and data types and enables easy and secure access to live xBase data from anywhere.
Our connector enables various ODBC-aware applications to establish a direct connection to FoxPro 2, Visual FoxPro, dBase (DBF), and other xBase databases, without involving any external libraries. A direct connection increases the speed of data transmission between an ODBC application and xBase database. It also simplifies the deployment, since there is no need to distribute any additional client software with the ODBC driver for xBase.
The driver is compatible with third-party tools for data analysis, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, etc.
For the complete list of compatible tools and environments visit the Compatibility page.
ODBC Driver for xBase can be used with 32-bit and 64-bit applications on both x32 and x64 platforms, so there is no need to additionally configure the driver, applications or environment.
With our fully Unicode-compliant driver, you can properly retrieve and modify any data in multilingual xBase databases, regardless of their character set: Latin, Cyrillic, Hebrew, Chinese, etc., and in any language environment.
ODBC driver for xBase provides options for ignoring corrupted data errors and metadata errors when opening a DBF table. Corrupted data is skipped, whereas the intact data is properly retrieved.
We have implemented advanced Data Conversion mechanisms that provide bi-directional mapping between any xBase and ODBC data types.
Moreover, with our driver you can perform bulk updates to xBase database by combining SQL statements into batches, thus simplifying and speeding up large data modification to xBase.
Our ODBC driver is a standalone installation file that doesn't require the user to deploy and configure any additional software such as a database client or a vendor library. Deployment costs are reduced drastically, especially when using the silent install method with an OEM license in large organizations that have hundreds of machines.
The driver provides full support for the Microsoft Open Database Connectivity (ODBC) interface, its functions, and data types. It offers advanced connection string parameters and allows any ODBC compliant desktop or web application to connect to xBase from various environments and platforms.
ODBC Driver for xBase supports:
Every operation with xBase becomes significantly faster using such capabilities of our driver as local data caching, connection pooling, and much more.
Visit our Support page to get instant help from knowledgeable and experienced professionals, a quick resolution of your problems, and nightly builds with hotfixes.
Devart ODBC drivers are verified to be compatible with leading analytics and reporting tools, various IDEs and programming languages. Get fast and secure access to your data in any application using our ODBC Drivers!
After the linux (DEB or RPM) driver is installed, a DSN with the name DEVART_XBASE is created. You can use it to test the connection with the XBASE server. For this, perform the following steps:
Database=< the path to the folder that contains the database files >
,
Format=< the used DBF format >
isql -v DEVART_XBASE
You can use the ODBC driver for xBase to connect to xBase from different ODBC-compliant reporting, analytics, BI, and ETL tools. For example, if you use DBeaver to review the MySQL data, you need to do the following:
We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.