416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
This is the support page for the legacy Dundas Dashboard application. For assistance with the current Dundas BI application please click here.
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Data Provider - Microsoft Visual Fox Pro / dBASE

Hide navigation
RSS
Modified on Fri, 28 Feb 2014 02:49 PM Categorized as Data Connectors
Click to return to: Documentation | Connecting to Data | Creating a Data Connector


Overview

Dundas Dashboard can connect to a Microsoft Visual FoxPro database or to dBASE files.

Connecting to FoxPro or dBASE

To connect to a Microsoft Visual FoxPro database (from the General tab of the Data Connector Designer screen):

  • Enter the fully qualified filename of your Microsoft Visual FoxPro database (&ie; the .DBC file) in the box provided.

To connect to dBASE (DBF) files:

  • Enter the full path to a folder containing your .DBF files. DBF files are used to store attribute data associated with ESRI shapefiles. See Adding Map Resources for more details.

Microsoft Visual FoxPro / dBASE provider option.

Microsoft Visual FoxPro / dBASE provider option.


Connection Error

If there is an error in connecting, see this link on possible causes and resolutions: FoxPro data provider error

Notes

  • You may need to install additional software on the server in order to connect to Microsoft Visual FoxPro database or dBASE files. See System Requirements for more details.
  • If your dBASE (DBF) file has numeric field values with precision greater than the precision of the corresponding field definition, you may get an exception like the following when previewing a virtual table based on the data connector: The provider could not determine the Decimal value. You can use a manual query to cast the fields to a different data type with higher precision.
  • Data Source Limitations

Related topics


Click to return to: Documentation | Connecting to Data | Creating a Data Connector

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.