Tuesday, December 11, 2018

Installing MDAC 32 bits on Windows 64 bits





I am trying to read xlsx file through CodeReady which requires ODBC 32bits. When installing MDAC 2010 32 bits on a Windows 10 64 bits, it ended up with a warning.

You cannot install the 32-bit version of Microsoft Access Database Engine 2010 because you currently have 64-bit Office products installed. If you want to install 32-bit Microsoft Access Database Engine 2010, 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 2010:
Microsoft Access database engine 2010 (English)



It seemed to be a nightmare. But the solution was far simple than that. I didn't uninstall everything 64bits. All I need was to install the 32 bits driver in the command line with the magic parameter /passive

AccessDatabaseEngine.exe /passive




It was just as simple as that. It was done nicely without giving me a headache.



It was a happy day!



Applying SMA10/20, SMA20/50 as trading signals

This is the comparison for results before and after applying SMA10/20 and SMA20/50 in the stock trader. Background Trading 3 stock ma...