This question has been flagged
3 Replies
18784 Views
pythoninstall
Avatar
Miku Laitinen

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.

Avatar
Discard
Avatar
Miku Laitinen
Author Best Answer

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:

  1. Download and install Python 2.6.6 x86 (msi installer)
  2. Download and install win32 version of pyodbc (exe installer)
  3. Copy Python26\Lib\site-packages\pyodbc.pyd to OpenERP\Server\server
  4. 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.

Avatar
Discard
Avatar
Favio Náquira
Best Answer

Search for the python folder and then

python -m pip install <mymodule>

Avatar
Discard
Haileslase Yakob

Thanks this worked for me

Aadeel S. Puri

Love you bro. thanks.

Avatar
Michael
Best Answer

@Favio Naquira's answer worked for me. Thumbs up chief.

Avatar
Discard