![]() So now it begins the amalgamation part of my experience. In that very moment I was convinced that it was time for the client to use a decent database system. The installation error can be bypassed by the following guide, but it requires the modification of some windows registry entries, which we cannot do in the client machines. Impatient launched the install but was greeted by:Īs I found out Microsoft does not support a side by side installation of Office 32 bit and the MS Access Database Engine in 64 bit. After some googling found the Microsoft Access Database Engine 2010 Redistributable which came in two flavours 32 and 64 bits. My first thought, after setting up the developement environment in a windows virtual machine, was to install the 64 bit version of the MS Access driver if Microsoft would have released it as a standalone executable. I was not familiar with the tool developed nor the Windows developing environment, but my intention was to finish the job as soon as possible. So here comes my task: convert the script to use sqlite and migrate the client MS Access DB to sqlite. The team found out, that the only official way to do this was to upgrade MS Access to 64 bit version… This was unacceptable because the license cost for the client would be unsustainable. Many “efforts” were done, which I am not aware of any, to find a workaround for the problem. The development phase of the project used a dummy MS Access DB and everything went well till the deployment date: the dll was not very happy with the 32 bit version of the MS Access driver library. The tool was written in C++ and compiled as 64 bit windows dll. My company built an automation tool for this client which should get the configuration parameters from that DB. Apparently one of our clients has a stone age MS Access DB to store configuration parameters of CAD automation scripts (we are in 2015)!. ![]() ![]() The necessity was urgent and with the highest priority and consisted in a sqlite DB migration. It begins with the necessity of one my managers to invite me for a two week period in the Italy office of the company. But in the recent two weeks I had an interesting work experience (and also funny) that I would like to share. I have always wanted to keep a blog but have always failed to create one, because of the lack of creativity and storytelling (as you will find out on this post). ![]()
0 Comments
Leave a Reply. |