Excel Static provider error message
Author: MacroTrader
Creation Date: 1/19/2011 10:13 AM
profile picture

MacroTrader

#1
I am tryng to create a Excel Datasource, using the Excel static provider extension. I am running a 64-bit operating system with Microsoft Access Database Engine 2010 Redistributable installed on it. WL 64-bit, and Excel 2010 32-bit.

however every time I try to create a datasource I am getting:



Any ideas why is this happening?

Thanks!!
profile picture

Eugene

#2
Review this note in provider's documentation and double check that a version of ACE appropriate to your system was installed:

Note to Wealth-Lab 64-bit edition users
profile picture

MacroTrader

#3
It seems that the Office "bitness" do matter.

I installed the "AccessDatabaseEngine.exe" file, because when I try to install the 64-bit version "AccessDatabaseEngine_x64.exe" as instructed in http://www2.wealth-lab.com/WL5WIKI/ExcelStatic.ashx I get this error.



I seems that it is because the Office "bitness".
profile picture

Eugene

#4
I see the point but since the provider doesn't depend on Excel & co. (and can work w/o Office installed), the only thing required is having the proper bitness of ACE. The provider will not work with an inappropriate version of ACE.

In this case, it seems that you have two alternatives:

1. If you would like to make the provider work in WLD6 x64, then remove 32-bit Excel, install 64-bit Excel, install ACE x64.
2. If for whatever reason it's not applicable, install WLD6 x86 (it will smoothly work side by side with 64-bit WLD6 on a 64-bit Windows) and use the provider there.
profile picture

MacroTrader

#5
About the alternatives:

1. The installation of Office I have is only 32-bit. I am not sure if MSFT will change it for a 64-bit.
2. For me is an alternative, what will I have to do?
profile picture

Eugene

#6
Download 32-bit version of Wealth-Lab, install it, run, download the Excel Static extension and install it using the 32-bit WL's Extension Manager, restart WLD6 x86. That's it.

P.S. Important note on installing extensions following installation of a different revision of WL side by side (e.g. WL x86 and x64, WLP and WLD etc.). After that, extensions downloaded from our site will install themselves into the last installed revision of WL (by default). In other words, if your previous revision was WLD6 x64, new extensions will be installed in WLD6 x86 if you click on a "Download extension" button.

To control which revision of WL should be an extension's destination, don't just open a newly downloaded extension with the help of Extension Manager (default action). Instead, save the extension's WLE file to disk in your browser, start the "right" Wealth-Lab, open Extension Manager, and drag the WLE file on it (or click the blue "Open WLE file" label).
profile picture

MacroTrader

#7
One more question. What are the advantadge of using WL64-bit over WL32-bit version on a 64-bit machine?
profile picture

Eugene

#8
First and foremost, the ability to use more RAM.

32-bit Windows can allocate up to 4 GB but only 2 GB (or 3 GB with the 3GB/LARGEADDRESSAWARE switch enabled) can actually be used for applications.

Not only 64-bit Windows can allocate these 4 GBytes but now they can also be fully used by 32 bit applications. And if you have RAM larger than 4 GB, true 64-bit applications like Wealth-Lab 6 64-bit Edition can use the entire installed memory.
profile picture

MacroTrader

#9
Thank you for your colaboration.