python - installing Pyodbc with Jython? -
platform: windows 7 (64 bit), jython version 2.7.10 "final release".
using java.sql classes access ms access dbases.
at point in future want move linux. @ point in future want move mysql/mariadb...
i thought it'd use more pythonic way, , seemed pyodbc might way go.
this attempt use pip install it:
d:\apps\jython2.7.0\bin>pip install pyodbc downloading/unpacking pyodbc downloading pyodbc-3.0.10.tar.gz (68kb): 68kb downloaded running setup.py (path:c:\users\chris\appdata\local\temp\pip_build_chris\pyodb c\setup.py) egg_info package pyodbc warning: no files found matching 'tests\*' warning: no files found matching 'readme.rst' installing collected packages: pyodbc running setup.py install pyodbc building 'pyodbc' extension error: compiling extensions not supported on jython complete output command d:\apps\jython2.7.0\bin\jython.exe -c "import s etuptools, tokenize;__file__='c:\\users\\chris\\appdata\\local\\temp\\pip_build_ chris\\pyodbc\\setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__). read().replace('\r\n', '\n'), __file__, 'exec'))" install --record c:\users\chri s\appdata\local\temp\pip-xb4a39-record\install-record.txt --single-version-exter nally-managed --compile: running install running build running build_ext building 'pyodbc' extension error: compiling extensions not supported on jython ---------------------------------------- cleaning up... ←[31mcommand "d:\apps\jython2.7.0\bin\jython.exe -c "import setuptools, tokenize ;__file__='c:\\users\\chris\\appdata\\local\\temp\\pip_build_chris\\pyodbc\\setu p.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\ n', '\n'), __file__, 'exec'))" install --record c:\users\chris\appdata\local\tem p\pip-xb4a39-record\install-record.txt --single-version-externally-managed --com pile" failed error code 1 in c:\users\chris\appdata\local\temp\pip_build_ch ris\pyodbc ←[0m←[31mstoring debug log failure in c:\users\chris\.pip\pip.log ←[0m d:\apps\jython2.7.0\bin>
anyone know whether can remedied/worked around?
have alternative suggestion pythonic access dbases using jython?
when move linux no longer have microsoft access odbc driver available (it windows-only). there other odbc options working access databases on non-windows platforms can less ideal.
for cross-platform solution use jython ucanaccess jdbc driver described in answer here:
read access database in python on non-windows platform (linux or mac)
Comments
Post a Comment