Database Provider
Supported ODBC Drivers (Recommended Driver at the top of list)
*The Microsoft dBase Driver is installed with Microsoft .Net
framework 1.1 as well as Microsoft Data Access Components (MDAC) 2.8
Application Compatibility with Recommended Driver
| Database Browser |
Query Editor |
Transfer Source |
Transfer Destination |
Query Source |
| Compatible |
Compatible |
Compatible |
Compatible |
Compatible |
SQL/Query Compatibility
| Basic Commands |
Advanced Commands |
| Supported |
Unsupported |
Extended Support Topics
Configuring your System DSN
1. Add a system DSN using your Data Source Administrator, if you are unsure how to perform this step, see the document
Configuring your ODBC System DSN
2. The dBase ODBC driver requres the path to where your dBase
database files are stored. You must uncheck the option labeled "Use
Current Directory" before the "Select Directory..." button will be
enabled. Once this is done, click the "Select Directory..." button and
browse to the local or network store of your database files. Click the
OK button to save your DSN configuration.
2a. Other options related to your Collating Sequence can be found by
expanding the ODBC dialog using the "Options" button, use these options
at your discretion.
3. Please see the document
Using ODBC in Data Mapper 2008 for assistance in using your configured DSN in Data Mapper 2008
Known Issues
Issue: Transfering tables that are over 12 characters long is not supported with Microsoft dBase ODBC Driver