I’m trying to link IQ data into Microsoft Word. To do this, I'm creating a Microsoft Office ODC file in IQ, following:
7.30 Live Links to IQ Grids from Word and Excel (node 1254)
This used to work, on another computer running Windows 7. On 10/06/2015 Wednesday, I note that I had successfully linked InfoQube to Excel.
7.30 Live Links to IQ Grids from Word and Excel (node 1254)
This used to work, on another computer running Windows 7. On 10/06/2015 Wednesday, I note that I had successfully linked InfoQube to Excel.
My current setup is a new computer running Windows 10 Creators’ Edition, Microsoft Office Subscription Product Microsoft Office 365, Version 1706 (Build 8229.2073 Click-to-Run), Office Updates are automatically downloaded and installed, Microsoft® Word 2016 MSO (16.0.8229.2073) 64-bit.
I’m using InfoQube 0.9.98a
I get this message in Excel if when I open the ODC file I specify ‘Add this data to the data model’:
We couldn't get data from the Data Model. Here's the error message we got:
Failed to connect to the server. Reason: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
Lots of advice on StackExchange programmers’ forum. I think this is only applicable by the developer, Pierre!
https://www.google.co.uk/search?q=infoqube+https%3A%2F%2Fstackoverflow…
If when I open the ODC file in Excel, I do not specify ‘Add this data to the data model’, I get this message:
Initialization of the data source failed.
Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see
this message again, create a new data source to connect to the database.
Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see
this message again, create a new data source to connect to the database.
No improvement if I recreate the ODC file.
Once I get the Excel link working, I plan to link to that from Microsoft Word.
Is there a workaround, or is a fix required in IQ?
Thanks for your advice.
Comments
Database Engine 2016 because you currently have 64-bit Office
products installed. If you want to install 32-bit Microsoft Access
Database Engine 2016, you will first need to remove the 64-bit
installation of Office products. After uninstalling the following
product(s), rerun setup in order to install 32-bit version of
Microsoft Access Database Engine 2016:
Office 16 Click-to-Run Extensibility Component
Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see
this message again, create a new data source to connect to the database.
Another option to try is to connect the "good old way" using named ODBC connection:
• Open the Control Panel (Win + X)
• (32-bit) (strange name for ODBC Data Source Administrator under Windows 10)
== On my PC, this needs to be: C:\Windows\SysWOW64\odbcad32.exe
• Under the User DSN tab, click add...
• Select Microsoft Access Driver (*.mdb)
• Click Finish
• The ODBC Microsoft Access Setup dialog will open
• Locate YourIQBase.sndb file and click OK
• In Excel connect to this data source
If this does work, within Excel, connect to an external database. The steps vary with each Excel version, but should be something like:
• Connect to external database
• Select driver
• Select file
• Select table
• OK
HTH !
Pierre_Admin
IQ Designer
MARK:
A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):
• The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder
• On my system, this is C:\Windows\SysWOW64\odbcad32.exe
• Choose Microsoft Access Driver (*.mdb)
• I click Finish
In the dialogue box which opens:
Under Database: Select…, I Select my IQbase, then name my Data Source Name IQMain9.
In Excel, I choose Data / Existing connections / Browse for more…
Choose +Connect to new data source
Choose ODBC/DSN, then Next
The DSN that I have just created is visible as IQMain9
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
"
Mark GREGORY, Hull, England- GMT +0/+1; EST +5
Has anyone gotten this to…
Has anyone gotten this to work recently? (I have not been successful....)
Hi Lucas, Did you install…
Hi Lucas,
Did you install the 64-bit ACE database driver and selected the 64-bit ODC file ?
(see 7. Live Links to IQ Grids from Word and Excel)
Hi Pierre, thanks for that…
Hi Pierre, thanks for that. I had been thinking that, since I have Access installed, that was enough, but I just tried installing the database driver as well (I tried with both the 2010 and 2016 versions). But when I try to open the ODC file in Excel and show the data in a sheet, I get the following:
Your IQBase is not password…
HTH !
Pierre_Admin
IQ Designer
Good point. I tried with a…
Good point. I tried with a new sample from a blank IQ Base, and it worked! Now I will just have to troubleshoot why the existing file isn't working...
Thanks for your help
Problem solved! I just had…
Problem solved! I just had to change the grid settings to be a flat list without context parents. I hadn't properly comprehended that this is a requirement.
Anyway, this is awesome. Having my IQ data in Excel opens a whole range of possibilities...
Flat list view should not be…
Great ! But Flat list view should not be required. If you can reproduce the issue with a sample app, please send it over !
(I wasn't able to reproduce…
(I wasn't able to reproduce it. When I opened the file in a clean version of IQ portable, the issue didn't happen.)