-
-
-
-
-
- Data Grid
- Data Grid Columns
- Open a Data Grid
- Sort Data Grid Columns
- Filter Data Grid
- Data Grid Grouping
- Merge Cells in Data Grid
- Data Grid Formatting
- Data Grid - Conditional Formatting
- Data Grid - Calculated Fields
- Data Grid Drill Down
- Data Grid Views
- Generate Report from Data Grid
- Refresh Data Grid
- Copy Data Grid Records
- Export Data Grid Data
- Show all articles ( 1 ) Collapse Articles
-
- Pivot Grid
- Pivot Grid Areas
- Pivot Grid Fields
- Pivot Grid Summarize
- Format Pivot Grid Fields
- Expand - Collapse Pivot Grid Columns
- Sort Pivot Grid
- Pivot Grid - Calculated Fields
- Pivot Grid Filters
- Pivot Grid Drill Down
- Pivot Grid Charts
- Pivot Grid Maps
- Pivot Grid Views
- Refresh Pivot Grid
- Export Data from the Pivot Grid
- Embed Pivot Grid into Report
- Show all articles ( 1 ) Collapse Articles
-
-
-
- Dashboard Items
- Dashboard Chart Item
- Dashboard Pie Item
- Dashboard Data Grid Item
- Dashboard Pivot Table Item
- Dashboard Gauge Item
- Dashboard Card Item
- Dashboard Scatter Chart Item
- Dashboard Treemap
- Dashboard Range Filter Item
- Dashboard Filter Elements Item
- Dashboard Text Item
- Dashboard Image Item
- Dashboard Group Item
-
-
-
-
- Schedule Server Jobs
- Add a Schedule Job - Simple Email
- Add Schedule Job - Merged Email
- Add Schedule Server Job - Merged Report
- Add Schedule Job - Alert DBxtra Users
- Add Schedule Server - Export Report Objects
- Add Schedule Job - FTP Upload
- Add Schedule Job - Print Report
- Add Schedule Job – Google Drive Upload
- Add Schedule Job – Dropbox Upload
- Add Schedule Job – Data Dump
- Edit - Delete Schedule Server Jobs
-
-
-
- DBxtra - Excel Reporting Service
- Install the XL Reporting Service
- XL Reporting Service - Driver Requirements
- XL Reporting Service Interface
- Connect Excel Reporting Service to DBxtra Report Repository and Login
- Insert the Report Object's Data into Excel
- Refresh Your Data
- Open DBxtra Reports and Dashboard from within Excel
- XL Reporting Service Security
-
- Articles coming soon
-
-
- Migrating the Report Web Service from legacy (DBxtra version 8.2.3 and prior) to responsive (DBxtra version 9.0.0 +)
- DBxtra version 7.1.0 on Internet Information Server – IIS 6
- DBxtra 7.1.0 on Internet Information Server – IIS 7
- DBxtra version 7.1 – Upgrade DBxtra Report Repository to SQL Server Express.
- How to configure DBxtra to use Internet Information Services on Windows Server 2012
- Open DBxtra reports in web browser on a new tab
- DBxtra 7 – Migrate the DBxtra Repository from a Network Share to Report Web Service
- Report Web Service: How to retain the minimalist menu look on custom styles (Legacy Report Web Service DBxtra ver. 8.2.3 amd prior)
- The Report Web Service shows empty reports or dashboards
- Pass login information from an external application to the DBxtra Report Web Service
- Pass login information from an external application to the DBxtra Report Web Service (DBxtra version 9+ - Responsive)
- Deploying the Report Web Service to Azure (Web Sites)
- What happens to report objects style customizations when I change interfaces in the Report Web Service
Error on Access, Excel or Text Data Connection
- Main
- KB + Tips
- KB - Data Connections
- Error on Access, Excel or Text Data Connection
If while trying to connect to an Access database, Excel or Text file, or while viewing a Heterogeneous Query you get the following message:
The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.
It means that you don’t have the 64 bits Access Database Engine installed on your computer, there are several possible solutions for this, which in order of recommendation are:
Install the 64 bits Access 2010 Database Engine
The Access Database Engine, it’s deployed, but not installed, by DBxtra’s installer, you can find it on DBxtra’s installation folder, located on C:\Program Files\DBxtra .NET by default, the setup program it’s named AccessDatabaseEngine_x64.
Note: The 64 bits Access Database Engine it’s not installed by default because it has known compatibility problems with 32 bits Office 2010, mainly with Excel.
Be aware, that if you have 32 bits Office already installed in your computer, then the setup program will refuse to continue, to force it to install, open a Command Prompt and navigate to the folder where the installer is and use the passive switch, writing something like this:
AccessDatabaseEngine_x64 /passive
Install 64 bits Office
For this you’ll need Office 2010 or newer; historically, Office has been a 32 bits application, so by default the setup program installs the 32 bits version of Office, so you’ll need to open the installation media and look for the x64 folder and run the setup program in there.
Note: If you want to create heterogeneous queries, we recommend you to install Office 2010, as Office 2013 have compatibility problems with such queries.
Be aware that this requires you to uninstall 32 bits Office, if you had it before, as Office can’t be installed side by side with other Office versions.
Note: Office 2016 has a new installation mechanism that doesn’t register the appropriate driver, so you’ll need to install the 64 bits Access 2010 Database Engine if you’re using any version of Office 2016.
Use 32 bits versions of DBxtra
DBxtra installs 32 bits versions of all their programs as a compatibility measure for databases which don’t have a 64 bits driver, or when you need 32 bits compatibility, on this case you can refer to the following article DBxtra 64 bits version for further instructions.
Troubleshooting
– I installed the Access Database Engine and now every time I open Excel or other Office application, it tries to repair its install.
-> Most likely, you have 32 bits Office 2010 installed, we recommend you to switch to 64 bits Office 2010 or install 32 bits Office 2013, if you have 32 bits Office 2013, let the repair finish and you shouldn’t see this error again.
– I need to have 32 bits Office for other applications.
-> We recommend you to install 32 bits Office 2013 and then install the 64 bits Access Database Engine, then open Excel and let it repair its install (it does this once), and it should be good to go.
– I need to use specifically 32 bits Office 2010, or I’m using Heterogeneous Queries, and I need to use specifically 64 bits Office 2013.
-> In both cases, your only option will be to use the 32 bits versions of DBxtra applications, as in the former, you won’t be able to install the 64 bits Access Database Engine, and in the later, heterogeneous queries won’t work properly on 64 bits DBxtra.
– I installed everything but DBxtra keeps showing me the same error message
-> If you’re using any version of Office 2016, you need to install the 64 bits Access 2010 Database Engine, otherwise, if DBxtra was open when you installed everything, then you need to close it and reopen it, if it wasn’t open, then you may need to restart your computer.