How to install and use pyodbc package with OpenOffice

[b_peter_7]

Hello OpenOffice community!

I have a question.
How to install and use pyodbc package with OpenOffice.
I use python 3.9 with anaconda, and I have already installed pyodbc but OpenOffice uses it's own python interpreter, under c:\Program Files (x86)\OpenOffice 4\program\python.exe what is a 2.7 version.

I need pyodbc in the 2.7 version also.
Could you please help?

Best regards,
Peter

[Zizi64]

Try the LibreOffice.

My LO 7.3.2 Prortable has Python 3.8.10 version inside the installed portable directory.

[Mountaineer]

As already told: If you want to use python for something serious, switch to LO because Python2 gets no updates since the last year. So don't start anything new.

Hints on installation are here:
https://github.com/mkleehammer/pyodbc/wiki/Install

Your next problem will be the missing pip, as Aoo/Lo ships without. In other cases I manually installed the necessary files, but when it comes to wheels (python) it gets complicated....

J.