Odoo Help


How do I install python modules in a Windows all-in-one installation?

Miku Laitinen
on 5/8/14, 12:46 PM 8,506 views

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.

Miku Laitinen
On 5/8/14, 1:20 PM

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.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 5/8/14, 12:46 PM
Seen: 8506 times
Last updated: 3/16/15, 8:10 AM