I have created a module for OpenERP which requires the pyodbc python module. Now I need to install pyodbc in the production environment (Windows Server 2012) which was installed using the OpenERP all-in-one setup. Apparently there is no python executable in the setup and OpenERP seems to use python26.dll instead.
How can I install additional python modules to the all-in-one installation?
I already installed Python 2.6.6 and pyodbc by using the .exe installers, but the pyodbc installer (naturally) installs the module in the Python libs directory. I copied the pyodbc.pyd file in Server\server directory but that didn't seem to work.
Well that didn't take long to solve.
My bells started ringing when I noticed the error message while installing the module. "Not a valid win32 application". It turns out that the all-in-one installation is actually for win32 / x86 architecture while I had installed x86_64 python and pyodbc.
So here's what I did:
- Download and install Python 2.6.6 x86 (msi installer)
- Download and install win32 version of pyodbc (exe installer)
- Copy Python26\Lib\site-packages\pyodbc.pyd to OpenERP\Server\server
- Restart the server
I really have to consider creating a custom installation of OpenERP with the 64-bit version of python 2.7 since running 32-bit python 2.6 on so new hardware feels like a waste.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/8/14, 12:46 PM|
|Seen: 4809 times|
|Last updated: 3/16/15, 8:10 AM|